Forum Discussion
Solved
Using a function with no rounding of numbers
Hello, As a teacher, I'm trying to get some semester grades calculated. How do I use functions like QUOTIENT, PRODUCT, SUM and have results that actually give values up to decimals? If I sel...
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
Thank you all! That makes a lot of sense and it worked!