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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"billatmei" wrote in message
...
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