Skip to main content
Solved

Create an IF formula from Single Select

  • September 19, 2024
  • 2 replies
  • 37 views
S
Forum|alt.badge.img+3

Hi All, 

Apologies if this is a question already answered. I want to create a IF formula that reads for a single select sell and alters a formula dependant on what the single select field says. 
For example- where Delivery Month is my single select cell 

=IF(OR(Delivery Month = "MARCH",Delivery Month = "APRIL",Delivery Month = "MAY"), (Cost*2*4)+8), IF(Delivery Month = "FEB", (Cost*2*6)+8, ))

When i place above in, the cell accepts it, but no calculation is done and cell is left blank. I am unsure why as i have checked spelling and spaces in my single select cell

 

Thanks in advance for your help

Best answer by TheTimeSavingCo

Try this:

IF( OR( {Delivery Month} = "MARCH", {Delivery Month} = "APRIL", {Delivery Month} = "MAY" ), (Cost*2*4)+8 ) + IF( {Delivery Month} = "FEB", (Cost*2*6)+8 )

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Try this:

IF( OR( {Delivery Month} = "MARCH", {Delivery Month} = "APRIL", {Delivery Month} = "MAY" ), (Cost*2*4)+8 ) + IF( {Delivery Month} = "FEB", (Cost*2*6)+8 )

Adam, Airtable Consultant - thetimesaving.company
dilipborad
S
Forum|alt.badge.img+3
  • SaragVGC
  • Author
  • New Participant
  • September 19, 2024

Try this:

IF( OR( {Delivery Month} = "MARCH", {Delivery Month} = "APRIL", {Delivery Month} = "MAY" ), (Cost*2*4)+8 ) + IF( {Delivery Month} = "FEB", (Cost*2*6)+8 )


Thank you, this helped!!! SO APPRECIATED

TheTimeSavingCo
Terms & ConditionsAccessibility statement