Skip to main content

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!


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

Reply


Terms & Conditions