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!