Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Strange result in Excel 2000
Hello folks, Have you encountered this in your Excel? I am using Excel 2000 SP3. Let's say you have: Column A1: 57.16 Column B1: 27.74 Column C1: 84.90 In Column D1, you have this formula: =($A$1+$B$1)-$C$1. Result would be 0 But if you have this formula in column E1: =IF(($A$1+$B$1)-$C$1) = 0, "it is zero", "it is not zero"). Result would be "it is not zero". Strange huh? It seems that it only happens to this set of number. Do you have the same result in the other Excel version? Thank you. -- ibertram ------------------------------------------------------------------------ ibertram's Profile: http://www.excelforum.com/member.php...o&userid=28730 View this thread: http://www.excelforum.com/showthread...hreadid=484221 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"1235" appears as "One thousand two hundred thirty five" | Excel Discussion (Misc queries) | |||
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. | Excel Discussion (Misc queries) | |||
Excel XP 2002 Vs. Excel 2000 | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |