Alternatives to QUOTIENT formula in Excel

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.




Share:

0 comments:

Post a Comment