QUOTIENT(numerator, denominator)

Returns the integer portion after division.

numeratorThe dividend.
denominatorThe divisor.

Remarks

* If any of the arguments are not numeric, then #VALUE! is returned.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=QUOTIENT(5,2) = 2
2=QUOTIENT(4.5,3.1) = 1
3=QUOTIENT(-10,3) = -3
4=QUOTIENT(10,-3) = -3
5=QUOTIENT(-10,"some text") = #VALUE!

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top