You can use the QUANTITY function to calculate the order quantity. The syntax for the QUANTITY function is:
Math.floor function returns the largest integer less than or equal to a given number. The syntax for Math.floor function is:
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