LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel result return wrong calcuation result garyww Excel Worksheet Functions 1 August 14th 06 11:14 AM
return wrong result of the cell garyww Excel Worksheet Functions 1 August 14th 06 05:51 AM
excel result return wrong calcuation result garyww Excel Worksheet Functions 0 August 14th 06 05:02 AM
excel result return wrong calcuation result garyww Excel Worksheet Functions 0 August 14th 06 05:02 AM
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 03:36 AM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"