Strange result in Excel 2000

Hello folks,

Have you encountered this in your Excel? I am using Excel 2000 SP3.

Let's say you have:
Column A1: 57.16
Column B1: 27.74
Column C1: 84.90

In Column D1, you have this formula: =($A$1+$B$1)-$C$1. Result would be 0
But if you have this formula in column E1: =IF(($A$1+$B$1)-$C$1) = 0, "it
is zero", "it is not zero"). Result would be "it is not zero". Strange
huh?

It seems that it only happens to this set of number.

Do you have the same result in the other Excel version?

Thank you.

It may be rounding error. The calculation may not product exactly zero.
--
Gary''s Student


"ibertram" wrote:

>
> Hello folks,
>
> Have you encountered this in your Excel? I am using Excel 2000 SP3.
>
> Let's say you have:
> Column A1: 57.16
> Column B1: 27.74
> Column C1: 84.90
>
> In Column D1, you have this formula: =($A$1+$B$1)-$C$1. Result would be
> 0
> But if you have this formula in column E1: =IF(($A$1+$B$1)-$C$1) = 0,
> "it
> is zero", "it is not zero"). Result would be "it is not zero".
> Strange
> huh?
>
> It seems that it only happens to this set of number.
>
> Do you have the same result in the other Excel version?
>
> Thank you.
>
>
> --
> ibertram
> ------------------------------------------------------------------------
> ibertram's Profile: http://www.excelforum.com/member.php...o&userid=28730
> View this thread: http://www.excelforum.com/showthread...hreadid=484221
>
>

See

http://support.microsoft.com/kb/7811...22120121120120

If do a search on Google you'll find many discussions and additional
information on this subject

--
Kind regards,

Niek Otten

"ibertram" <[email protected]> wrote in
message news:[email protected]...
>
> Hello folks,
>
> Have you encountered this in your Excel? I am using Excel 2000 SP3.
>
> Let's say you have:
> Column A1: 57.16
> Column B1: 27.74
> Column C1: 84.90
>
> In Column D1, you have this formula: =($A$1+$B$1)-$C$1. Result would be
> 0
> But if you have this formula in column E1: =IF(($A$1+$B$1)-$C$1) = 0,
> "it
> is zero", "it is not zero"). Result would be "it is not zero".
> Strange
> huh?
>
> It seems that it only happens to this set of number.
>
> Do you have the same result in the other Excel version?
>
> Thank you.
>
>
> --
> ibertram
> ------------------------------------------------------------------------
> ibertram's Profile:
> http://www.excelforum.com/member.php...o&userid=28730
> View this thread: http://www.excelforum.com/showthread...hreadid=484221
>

Thanks dude..
the rounding solves the problem.
Thanks

More information provided under the separate thread in
microsoft.public.excel

Jerry

ibertram wrote:

> Hello folks,
>
> Have you encountered this in your Excel? I am using Excel 2000 SP3.
>
> Let's say you have:
> Column A1: 57.16
> Column B1: 27.74
> Column C1: 84.90
>
> In Column D1, you have this formula: =($A$1+$B$1)-$C$1. Result would be
> 0
> But if you have this formula in column E1: =IF(($A$1+$B$1)-$C$1) = 0,
> "it
> is zero", "it is not zero"). Result would be "it is not zero".
> Strange
> huh?
>
> It seems that it only happens to this set of number.
>
> Do you have the same result in the other Excel version?
>
> Thank you.