IFS function evaluates multiple conditions and returns a value that corresponds to the first true condition. The syntax for the IFS function is: IFS(condition1, value1, [condition2, value2, …]) where
Standard shipping fee If the order amount is greater than $500, shipping fees will be zero. Otherwise, a standard fee of $25. IFS(Order amount > 500, CURRENCY("$", 0), CURRENCY("$", 25)) Shipping fee based on the delivery zone Instead of standard shipping fee of $50 for all orders above $500, we can use the FEE function to calculate the shipping fee based on the zone selected by the user. IFS(Order amount > 500, CURRENCY("$", 0), FEE("$", Choose the delivery zone, 10, 15, 12))
Click Submit to finish.
Use our readymade templates to create order form
Try It Free