Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
very strange behavior of if function resulting in wrong result which might be
a bug. try it out at your own, and try other values just remember the same difference. a1=300 b1=303,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"OK";"NOT OK") the result of e1 should be "OK" but its "NOT OK" a1=200 b1=203,6 c1=b1-a1 d1=3,6 e1=if(c1<=d1;"OK;"NOT OK") the result of e1 is "OK" What the hell is going on ? It does not help to format the cell's. Have i found a bug, and if it is i will call it a MAJOR BUG which could be the reson of world economic crisis ;o) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL 2000 - IF function returns wrong result from logical test | Excel Worksheet Functions | |||
Wrong result on dividing 2 values | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions | |||
excel result return wrong calcuation result | Excel Worksheet Functions |