Funtions return wrong result BUG in Execel ???

  • Thread starter Thread starter abracadabra
  • Start date Start date
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.
 
Read the replies to your other posts.
Click to expand...

Why don't you look at the replies in your previous post?
Click to expand...

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.
Click to expand...



----- 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
 
<< 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.
Click to expand...

Why don't you look at the replies in your previous post?
Click to expand...

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.
Click to expand...



----- 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
 
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
Click to expand...
 
The main reason for replying to duplicate posts
is so that others don't waste time with questions
that have already been answered.
Click to expand...

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.
 
Back
Top