Products
Neartail
Take food orders for frequently changing menu
Order form You are here
Calculate order amount in Google Forms
WhatsApp form
Take online orders from your WhatsApp contacts
Payment form
Accept payment in Google Forms
Website builder
Organize your forms like Linktree
Solutions
Meal Prep Software
Meal prep software for weekly changing menu
Online Canteen
Take canteen orders for weekly changing menu
You can use the QUANTITY() function to calculate the total order quantity and apply the discount. For example, if you would like to offer a 10% discount on the total amount for orders quantities above 10, then you can use the following formula.
IFS(QUANTITY() >= 10, TOTAL() * 0.10, 0)
You can use the TOTAL() function to calculate the total order amount and apply the discount. For example, if you would like to offer a 20% discount on the total amount for orders above $100, then you can use the following formula.
IFS(TOTAL() >= 100, TOTAL() * 0.20, 0)
Click Submit to finish.
Last updated: 12/18/2024