How to add a fixed shipping fee regardless of the order amount or delivery zones?

You can use the CURRENCY function with a number value to set a fixed shipping fee. Add a short answer question in Google Forms and write the formula using CURRENCY function in Formfacade.

How to setup a fixed shipping fee?

Use CURRENCY function to set a fixed shipping fee

We will use the currency function with a number value to set a fixed shipping fee. CURRENCY function displays the number in currency format. The syntax for the currency function is:

CURRENCY(symbol, number)
where

  • symbol - The currency symbol to be displayed
  • List number - This could be a number or a calculation that returns a number.

For example

  • To set a fixed shipping fee of $10, you can write the formula CURRENCY("$", 10)
  • To set a fixed shipping fee of €4.99, you can write the formula CURRENCY("€",4.99)

How to calculate the total amount including the fixed shipping fee?