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.

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.

Read the replies to your other posts.

Regards,
Fred.

"abracadabra" wrote in message
...
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.

On Dec 27, 7:26*am, "Fred Smith" wrote:
Read the replies to your other posts.

On Dec 27, 7:23 am, Mike H wrote:
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"
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 a

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" wrote:
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
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

On Dec 27, 9:30 am, Templar wrote:
I don't see any messges after December 23, 2008?
Yet, I receive notifications of posted answers.
--
Templar

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

"joeu2004" wrote in message
...
On Dec 27, 7:26 am, "Fred Smith" wrote:
Read the replies to your other posts.

On Dec 27, 7:23 am, Mike H wrote:
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"
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 a

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" wrote:
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
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

On Dec 27, 9:30 am, Templar wrote:
I don't see any messges after December 23, 2008?
Yet, I receive notifications of posted answers.
--
Templar

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

"abracadabra" wrote in message
...
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.

What's with the web interface?

Shane Devenshire

"joeu2004" wrote in message
...
On Dec 27, 7:26 am, "Fred Smith" wrote:
Read the replies to your other posts.

On Dec 27, 7:23 am, Mike H wrote:
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"
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 a

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" wrote:
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
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

On Dec 27, 9:30 am, Templar wrote:
I don't see any messges after December 23, 2008?
Yet, I receive notifications of posted answers.
--
Templar

On Dec 27, 8:39*am, "Fred Smith" wrote:
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.

Shane, I think they are referring to the Communities site
http://www.microsoft.com/office/comm...s/default.mspx

Happy New Year
Bernard V Liengme

"Shane Devenshire" wrote in message
...
What's with the web interface?

Shane Devenshire

"joeu2004" wrote in message
...
On Dec 27, 7:26 am, "Fred Smith" wrote:
Read the replies to your other posts.

On Dec 27, 7:23 am, Mike H wrote:
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"
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 a

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" wrote:
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
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

On Dec 27, 9:30 am, Templar wrote:
I don't see any messges after December 23, 2008?
Yet, I receive notifications of posted answers.
--
Templar