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, …])
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.
To use this feature, you need our Gsuite addon.
Install this addon to customize Google Forms.
Try It Free