Quotient formula returns integer portion of a division. Its syntax is "QUOTIENT(numerator, denominator)". Similarly INT and ROUNDDOWN formulas can be used as an alternative to QUOTIENT.
For example:
119/15 = 7.93
In this example quotient is 7. Now, lets use above three formulas and check results
"=QUOTIENT(119,5)" = 7
"=INT(119/15) = 7
"=ROUNDDOWN(119/5,0)
The second argument in ROUNDDOWN is the number of digits to round down after decimal. As we want only the integer portion of division, it is set to zero.
0 comments:
Post a Comment