Forum Discussion

TLinde's avatar
TLinde
Copper Contributor
Nov 09, 2020
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...
Formulas and Functions
  • ExcelExciting's avatar
    ExcelExciting
    Nov 09, 2020

    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

ExcelExciting's avatar
ExcelExciting
MVP
Nov 09, 2020

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

Resources