You can use the QUANTITY function to calculate the order quantity. The syntax for the QUANTITY function is: QUANTITY(currency) where

For example:

Math.floor function returns the largest integer less than or equal to a given number. The syntax for Math.floor function is: Math.floor(number) where

Baker's dozen is 13. To offer a free cookie for every dozen that a user orders, we can calculate the number of dozens by dividing the order quantity by 12. Since we only need a round number, we can use the Math.floor function to calculate the exact number of free cookies. Math.floor( Order quantity / 12 )

Click Submit to finish.

To use this feature, you need our Gsuite addon. Install this addon to customize Google Forms.

Try It Free