No Rounding - need full decimal value

[Willie - NMSVH]

Help, my totals keep rounding up!!!

I have the following in a worksheet which gives me a
total of $87.00, but should be $86.85 to correctly bill
the school districts we service.

1) Sum(D21:J21) which equals 116 (minutes) in cell K21
2) K21/60 which equals 1.933333 (hours) in cell L21
3) L21 is then multiplied by 45(dollars) which equals

I sure would appreciate any/all help fixing this problem.

 

[Michael J. Malinsky]

This does not apppear do be an Excel problem. I did the math both in Excel
and on my trusty adding machine. Excel came up with 87.00 while the adding
maching gave 86.9999999998.

It appears that in order to arrive at an answer of 86.85, you would have to
round off the 1.93333 to 1.93 (1.93 x 45 = 86.85 according to Excel and the
adding machine).

So it seems that the answer of 87.00 given be Excel is correct based on the
full value of 116/60 = 1.933333333333....

Are you rounding off when you do the math outside of Excel?

HTH


--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[JE McGimpsey]

Hmmm...

=116/60 * 45 DOES equal 87.00

Your formulae *are* using all the decimals, but your desired result
isn't.

If you want to get exactly 86.85, which is 1.93000000 * 45, use

=ROUND(L21,2)*45

 

[Michael]

Hi Willie

Have you looked at Format/ Cells/Number/Currency/2 decimal
places.

Regards
Michael

 

[Ron Rosenfeld]

Help, my totals keep rounding up!!!

I have the following in a worksheet which gives me a
total of $87.00, but should be $86.85 to correctly bill
the school districts we service.

1) Sum(D21:J21) which equals 116 (minutes) in cell K21
2) K21/60 which equals 1.933333 (hours) in cell L21
3) L21 is then multiplied by 45(dollars) which equals

I sure would appreciate any/all help fixing this problem.

Tools/Options/Edit and ensure that Fixed Decimal is DEselected.
--ron

 

[Willie - NMSVH]

Thanks, rounding only the summed values did the trick.