| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does excel sometimes subtract numbers incorrectly?
I have checked and rechecked the formula -- it is correct. I have seen excel
round off incorrectly but not subtract whole numbers incorrectly. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does excel sometimes subtract numbers incorrectly?
spotoeg wrote...
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does excel sometimes subtract numbers incorrectly?
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 "spotoeg" wrote in message ... |I have checked and rechecked the formula -- it is correct. I have seen excel | round off incorrectly but not subtract whole numbers incorrectly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row of numbers adding incorrectly. | Excel Discussion (Misc queries) | |||
| Subtract numbers | Excel Discussion (Misc queries) | |||
| subtract 3 numbers and 2 cells | New Users to Excel | |||
| How to subtract two numbers in excel ? | Excel Worksheet Functions | |||
| subtract all numbers in an array | Excel Worksheet Functions | |||
Hybrid Mode
