| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel extending result to multiple decimals
I have an issue with excel:
cell c7: 123200 (entered direct into cell-not calculated) cell d7: -123151.6 (entered direct into cell-not calculated) cell e7 forumula: =sum(c7:d7) result displayed: 48.4 (appears correct) cell j7 value = 48.4 (entered direct into cell-not calculated) cell j7 formula: =j7=e7 result: FALSE When I copy paste special values from cell e7 to another cell the result is 48.3999999999942. How can that be? What is the problem? This is simple math. It has been tested on multiple computers with similar configuration. Please help. MS office 2003 (11.6355.6408) SP1 MS Windows XP V2002 SP1 dls2193 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
| Multiple workbooks on Taskbar in Excel 97 | Excel Discussion (Misc queries) | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Threaded Mode
