Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Funtions return wrong result BUG in Execel ???
IF funtion and or funtion returningen wrong result when using decimal numbers.
Exampel: a1= 300 b1=303,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"ok";"not ok") this one returns "not ok" which is wrong result !!?? a1=300 b1=303,5 c1=b1-a1 d1=3,5 e1=if(c1<=d1;"ok";"not ok") this one returns "ok" which is right result. Be aware that c1 and d1 is equal in both exampels, only the decimal value changes. Have i found a MAJOR NUG in Excel or am i doing something wrong ? I've also tried formatting the cells but i doesnt help in anyway. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
return wrong result of the cell | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions |