Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Create an IF formula from Single Select

Topic Labels: Formulas
Solved
Jump to Solution
1206 2
cancel
Showing results for 
Search instead for 
Did you mean: 
SaragVGC
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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
)

Screenshot 2024-09-19 at 10.07.34 AM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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
)

Screenshot 2024-09-19 at 10.07.34 AM.png

Thank you, this helped!!! SO APPRECIATED