Why does excel sometimes subtract numbers incorrectly?

[spotoeg]

I have checked and rechecked the formula -- it is correct. I have seen excel
round off incorrectly but not subtract whole numbers incorrectly.

 

[Harlan Grove]

I have checked and rechecked the formula -- it is correct. I have
seen excel round off incorrectly but not subtract whole numbers
incorrectly.

What's the formula and what are the values?

 

[Niek Otten]

You really need to give more information!

What numbers? How are they formatted? What formula leads to their results? What are the input values? What result did you expect?
What did you get instead?

But most likely you ran into (at least) one of the standard computer behavior traps:

http://mvp.support.microsoft.com/default.aspx

http://www.cpearson.com/Excel/rounding.htm


--
Kind regards,

Niek Otten
Microsoft MVP - Excel



|I have checked and rechecked the formula -- it is correct. I have seen excel
| round off incorrectly but not subtract whole numbers incorrectly.