rounding problem

  • Thread starter Thread starter memac19
  • Start date Start date
M

memac19

I have set up a spreadsheet, but can't get my final value to round up
the correct way
ex
Attached is my example that I am having problems with. The cell in
question is E21 (701.98). This is a result of summing up E14:E19. I
have formatted it to show 2 decimal places, problem is when adding up
these numbers it is taking more than 2 decimal places and in turn
showing 701.98 vs 701.99. Is there a way that I can have the whole
sheet take 2 decimal places , so it will show 701.99. I is a unique
instance, but because the number are how they are, it looks to the
naked eye that it is an adding error.

Thanks,

Attachment filename: dealer invoice22.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=418625
 
Hi

Excel works correct. Your values in cells E14:E19 are only formated
with two decimals. Then calculation the sum of them, Excel uses all
decimals.
One solution for your problem: Use ROUND in cells E14:E19:
=ROUND([your formula],2)
HTH
Frank
 
Or, often a good solution for financial spreadsheets:

Tools>Options>Calculation, check Precision as displayed.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Frank Kabel said:
Hi

Excel works correct. Your values in cells E14:E19 are only formated
with two decimals. Then calculation the sum of them, Excel uses all
decimals.
One solution for your problem: Use ROUND in cells E14:E19:
=ROUND([your formula],2)
HTH
Frank
I have set up a spreadsheet, but can't get my final value to round up
the correct way
ex
Attached is my example that I am having problems with. The cell in
question is E21 (701.98). This is a result of summing up E14:E19. I
have formatted it to show 2 decimal places, problem is when adding up
these numbers it is taking more than 2 decimal places and in turn
showing 701.98 vs 701.99. Is there a way that I can have the whole
sheet take 2 decimal places , so it will show 701.99. I is a unique
instance, but because the number are how they are, it looks to the
naked eye that it is an adding error.

Thanks,

Attachment filename: dealer invoice22.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=418625 ---
Message posted
Click to expand...
Click to expand...
 
Back
Top