How to calculate sales tax and add it to the total amount?

You can add a short answer question in Google Forms and then write the formula in Formfacade to automatically calculate the taxes based on order amount.

You can add a short answer question in Google Forms and then write the formula in Formfacade to automatically calculate the taxes based on order amount.

How to calculate the taxes based on order amount?

Step 1: Add a short answer question with number response validation in Google Forms.
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 sales tax.

Formula to calculate the taxes

If you know the tax rates that you need to charge your customers and pay the local tax authority, you can easily write the formula to calculate the taxes. Otherwise, you can check with your accountant to confirm the tax rates.

Let's say the sales tax is 7%. You will have to simply multiply order amount by 0.07 to calculate the tax. We can use the CURRENCY function to format and display the calculated tax as a currency.

CURRENCY("$", Order amount * 0.07)

Step 3: Field settings screen will be displayed. Select the "Answer" tab and write the formula to calculate the taxes as shown below.

How to calculate the total amount including taxes?

Step 1: Add a short answer question with number response validation in Google Forms.
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 total amount.
Step 3: Field settings screen will be displayed. Select the "Answer" tab and write the formula to calculate the total amount as shown below.
Made with formfacade