Skip to main content

How to combine "IF" and "SWITCH" formulas

  • June 8, 2021
  • 1 reply
  • 20 views
E

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

R
Forum|alt.badge.img+3
  • Raminder_Singh
  • Participating Frequently
  • June 8, 2021

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

Terms & ConditionsAccessibility statement