Forum Discussion
Using a function with no rounding of numbers
Hi TLinde
Note that QUOTIENT returns the integer portion of a division.
If you want to divide numeric values, you should use the "/" operator as there no DIVIDE function in Excel and note that QUOTIENT doesn't return a remainder part of the value.
That is reason you are not getting the value as 0.33 while using QUOTIENT.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more
The QUOTIENT function divides the first parameter by the second, then returns an integer result—rounded down.
In your problem, you are looking at 1/3 Since the numerator is less than the denominator, you will always get 0 from the QUOTIENT function.
It is working exactly as Microsoft programmed it.
If you would like to get the result, then use a formula like either of:
=1/3
=ROUND(1/3,2)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.