rounding down to positive when adding cells

[Guest]

When I am adding two cells excel wants to round down to a positive number. I
have tried to use the accounting and the currency function with no success.
Example would be =C5 ($23.81) + E5 (23.82) I get $47.62 not $47.63

 

[Guest]

What is probably happening is those number have extra precision beyond the 2
decimal's displayed. e.g. C5 might be 23.805 and E5 might be 23.818. When
you add these numbers you will get 47.62 when rounded to 2 decimal places
(even though it APPEARS you should get 47.63 when you add the rounded
versions). If you really want to get rid of the extra precision in C5 and E5
do the following:

<Tools>
<Options>
"Calculation" tab
Check "Precision as displayed"

This will calculate based on the amount of precision you choose to display
in the cell.

Does that help?

 

[Bernard Liengme]

I expect the numbers are not exactly 23.81 and 23.82 but maybe something
like 23.808 and 23.816. These add to 47.624 which gets displays as 46.62
when the format is 2 decimals.
How to get what you want?
a) =ROUND(C2,2)+ROUND(E2,2)
OR
b) Tool | Options | Calculations and check Precision as Displayed
While (a) is more work, you must be careful that (b) may affect other
workbooks that you open.
best wishes