View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H[_3_] Mike H[_3_] is offline
external usenet poster
 
Posts: 39
Default Funtions return wrong result BUG in Execel ???

Why don't you look at the replies in your previous post?

On Dec 28, 2:52*am, abracadabra
wrote:
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.