Using =Quotient formula and it is rounding the answers...

[Mbay]

I am using a formula in excel and I need help.

Basically here is an example of what I am doing, I entered in the formula =QUOTIENT(1470, 30.42) and it is rounding the answers. I didn't put 1470 acutally, I referenced the column it's in, but I need the answers to come out to the exact number (i.e. it says in excel 48.00 when i need what it should be 48.32). Does anyone know how to remedy this??

 

[barry houdini]

That's what QUOTIENT is supposed to do. It only returns the integer portion of the divison, for your requirement just use

=1470/30.42

or the relevant cell references....

 

[Aladin Akyurek]

That's what QUOTIENT does: Return the integer part of a division.

Use instead the / operator:

=A1/B1

where A1 is 1470 and B1 30.42.

 

[Joe4]

Why not just use:
=1470/30.42
or
=A1/30.42
or
=A1/B1

You can use formatting and/or the ROUND function to limit the number of decimals to show.+

 

[Mbay]

Thank you so much for your help! I don't have to do this function often and you've all been a great help! Thanks again!