Creating conditional formula that doesn't calculat...

[Erez_Malka]

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!

[Raminder_Singh]

Erez_Malka:

IF ({Send to FBA},SWITCH({Product Type}, ‘Individual’, {Arrive to Prep Center}*1.5, ‘Return’,{Arrive to Prep Center}*2.5)

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))