Funtions return wrong result BUG in Execel ???

A

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.
 
J

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

Tufail said:
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
 
F

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

Tufail said:
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
 
S

Shane Devenshire

What's with the web interface?

Shane Devenshire

joeu2004 said:
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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top