rounding problem

[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

 

[Frank Kabel]

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

 

[Niek Otten]

Or, often a good solution for financial spreadsheets:

Tools>Options>Calculation, check Precision as displayed.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

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 ---