How to calculate your free shipping threshold

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

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

How to calculate shipping fees based on order amount?

Step 1: Add a short answer question with the number response validation for delivery fee.
Step 2: Click on the Addon icon > Select Neartail > Select Customize this form > Click on the Proceed button.
In the Neartail customize interface, click on the ⚙️icon next to the short answer question for delivery fee.

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

Step 3: Field settings screen will be displayed. Select the "Answer" tab and write the formula to calculate the delivery fee based order amount.
Made with formfacade

Last updated: