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.
Use our readymade templates to create order form
Try It Free