Funtions return wrong result BUG in Execel ???

[abracadabra]

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.

 

[Mike H]

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

 

[Fred Smith]

Read the replies to your other posts.

Regards,
Fred.

 

[joeu2004]

Read the replies to your other posts.

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

My guess is: because he can't see them (yet). In fact, even the OP's
original posting does not appear (yet) when I use the web interface to
the MS Discussion Groups. It is a problem that both of you seem to be
aware of, judging from your ealier postings copied below.



----- related posting -----

From: "Fred Smith" <[email protected]>
Date: Dec 27, 7:20 am
Subject: not message showing after 23 Dec 2008
To: microsoft.public.excel.misc


This problem has been reported several times. Your choices are:

1. Use a newsreader (like Outlook Express or Microsoft Mail) to access
the
groups.
2. Access the groups through Google.
3. Wait for Microsoft to fix the problem.

I'd go with number 1.

Regards,
Fred

i don't know but somehow all messaged are not showing, i am not able to
view
messages greater than 23 Dec 2008.

----- related posting -----

From: Mike H <[email protected]>
Date: Dec 26, 2:11 pm
Subject: Microsoft's Excel Discussion Group Site is screwed up.
To: microsoft.public.excel.misc


It does that frequently, they'll fix it in the next day or so

 

[Fred Smith]

<< It is a problem that both of you seem to be
aware of, judging from your ealier postings copied below.>>

We are. The main reason for replying to duplicate posts is so that others
don't waste time with questions that have already been answered.

Regards,
Fred.

Read the replies to your other posts.

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

My guess is: because he can't see them (yet). In fact, even the OP's
original posting does not appear (yet) when I use the web interface to
the MS Discussion Groups. It is a problem that both of you seem to be
aware of, judging from your ealier postings copied below.



----- related posting -----

From: "Fred Smith" <[email protected]>
Date: Dec 27, 7:20 am
Subject: not message showing after 23 Dec 2008
To: microsoft.public.excel.misc


This problem has been reported several times. Your choices are:

1. Use a newsreader (like Outlook Express or Microsoft Mail) to access
the
groups.
2. Access the groups through Google.
3. Wait for Microsoft to fix the problem.

I'd go with number 1.

Regards,
Fred

i don't know but somehow all messaged are not showing, i am not able to
view
messages greater than 23 Dec 2008.

----- related posting -----

From: Mike H <[email protected]>
Date: Dec 26, 2:11 pm
Subject: Microsoft's Excel Discussion Group Site is screwed up.
To: microsoft.public.excel.misc


It does that frequently, they'll fix it in the next day or so

 

[Shane Devenshire]

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

 

[Shane Devenshire]

What's with the web interface?

Shane Devenshire

My guess is: because he can't see them (yet). In fact, even the OP's
original posting does not appear (yet) when I use the web interface to
the MS Discussion Groups. It is a problem that both of you seem to be
aware of, judging from your ealier postings copied below.



----- related posting -----

From: "Fred Smith" <[email protected]>
Date: Dec 27, 7:20 am
Subject: not message showing after 23 Dec 2008
To: microsoft.public.excel.misc


This problem has been reported several times. Your choices are:

1. Use a newsreader (like Outlook Express or Microsoft Mail) to access
the
groups.
2. Access the groups through Google.
3. Wait for Microsoft to fix the problem.

I'd go with number 1.

Regards,
Fred





----- related posting -----

From: Mike H <[email protected]>
Date: Dec 26, 2:11 pm
Subject: Microsoft's Excel Discussion Group Site is screwed up.
To: microsoft.public.excel.misc


It does that frequently, they'll fix it in the next day or so

 

[joeu2004]

The main reason for replying to duplicate posts
is so that others don't waste time with questions
that have already been answered.

Agreed. Your posting was merely informative. I lumped it together
with MikeH's posting, which seemed unduly judgmental. My bad!

I have no problem with people posting duplicates because they believe
their first posting was lost, either due to an error message, which is
often misleading, or after not seeing the posting after waiting a
reasonable amount of time. In this case, the OP waited 16 hours.
More than reasonable, IMHO.

But in such cases, it behooves the person posting the duplicate to
mention it in the beginning (e.g. "please forgive the duplicate
posting") so that other people who cannot help themselves from
criticizing others might find some solace.

 

[Bernard Liengme]

Shane, I think they are referring to the Communities site
http://www.microsoft.com/office/community/en-us/default.mspx

Happy New Year
Bernard V Liengme