Hi,
Computers work in binary, we work in decimals
Here is everything you need to know about this issue (and more):
http://support.microsoft.com/kb/78113/en-us
http://support.microsoft.com/kb/42980
http://support.microsoft.com/kb/214118
http://www.cpearson.com/excel/rounding.htm
http://docs.sun.com/source/806-3568/ncg_goldberg.html
If this helps, please cliick the Yes button.
Cheers,
Shane Devenshire
"abracadabra" wrote in message
...
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.