Re: Strange result in Excel 2000
- From: "Don Guillett" <donaldb@xxxxxxx>
- Date: Fri, 11 Nov 2005 08:04:03 -0600
might be true in all versions due to 15 digit. Use the ROUND function.
--
Don Guillett
SalesAid Software
donaldb@xxxxxxx
"ibertram" <ibertram.1ybtpb_1131702601.2855@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:ibertram.1ybtpb_1131702601.2855@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=28730
> View this thread: http://www.excelforum.com/showthread.php?threadid=484222
>
.
- References:
- Strange result in Excel 2000
- From: ibertram
- Strange result in Excel 2000
- Prev by Date: outlook import dl
- Next by Date: Display custom dockable window in excel
- Previous by thread: Strange result in Excel 2000
- Next by thread: Re: Strange result in Excel 2000
- Index(es):
Relevant Pages
|
