### You can use IFS function to set shipping costs as zero for total amounts exceeding the specified threshold amount.

#### Use IFS function to set shipping costs based on order amount

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

• condition1 - The first condition to be evaluated.
• value1 - The returned value if condition1 is TRUE.
• condition2, value2, … - Additional conditions and values if the first one is evaluated to be false.

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