| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiplication error
I noticed that Excel 2003 calculates:
7.5*1.2=8.7 when the correct answer is 9.0. It did this as part of a formula where the 1.2 answer came from calculating another set of numbers. When I asked Excel to calculate this answer by simply inputting those two numbers the correct answer of 9.0 came out. Does anyone have an answer as to why it does that?! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| ERROR | Excel Discussion (Misc queries) | |||
Threaded Mode
