Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to combine "IF" and "SWITCH" formulas

Topic Labels: Formulas
264 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to combine “IF” and “SWITCH” formulas into one?
i am trying this formula and i am keep getting an error:
IF ({Send to FBA},SWITCH({Product Type}, ‘Individual’, {Arrive to Prep Center}*1.5, ‘Return’,{Arrive to Prep Center}*2.5)

The “Send to FBA” is a checkbox field
When i do this formula alone it works great:
SWITCH({Product Type}, ‘Individual’, {Arrive to Prep Center}1.5, ‘Return’,{Arrive to Prep Center}2.5)

But i want this formula to work only if “Send to FBA” is checkbox!

1 Reply 1

Looks like you are missing the closing parenthesis. Just add a ) to your formula and it should work: IF ({Send to FBA},SWITCH({Product Type}, 'Individual', {Arrive to Prep Center}*1.5, 'Return',{Arrive to Prep Center}*2.5))