| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007- formula =SUM(850*77.1) returns incorrect answer = 1000
Enter the formula: =SUM(850*77.1) and you get 100000. In 2003, you get the
correct answer of 65535. Any idea why? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula incorrect answer | Excel Discussion (Misc queries) | |||
| Same formula referencing same cells returns incorrect results, randomly, when pasted into new worksheet | Excel Worksheet Functions | |||
| Help with formula that unexpectedly returns an answer | Excel Worksheet Functions | |||
| sumif formula returns incorrect value | Excel Worksheet Functions | |||
| Formula giving incorrect answer... | Excel Discussion (Misc queries) | |||
Threaded Mode
