I believe this is an excel bug in which I will do my best to explain.
Stick with me on this one.
I am using Excel 2000 v9.0.2720
I have a column (column C) of numbers like this:

C4 1,689,772.85
C5 (1,660,919.76)
C6 0.00
C7 28,853.09 =sum(C4:C6)
C8
C9
C10 28,853.09 =sum(C7:C9)
C11
C12 8,187.14
C13 13,257.13
C14 50,297.36 =sum(C12:C13)
C15 -363.80
C16 -3.46
C17
C18
C19 49,930.10 =sum(C14:C18)
C20
C21
C22 49,930.10 =sum(C19:C21)
C23
C24
C25
C26
C27
C28 49,930.10 =sum(C22:C27)
C29
C30
C31
C32 ERROR This is formula:
=if(C19=C28,0,"ERROR")

Now, as you can see C19 DOES EQUAL C28 and therefore 0 should print in
C32.
If I change C7 from the SUM of C4:C6 and simply type in 28853.09 (Which
is the same as the sum) then my formula on C32 works and the 0 prints in
C32
Even more strange.... If I leave C7 as =sum(c4:c6) but change the
numbers in C4 to C6 to 28854.09 and -1.00 respectively giving me the
same 28853.09 as before the C32 formula works again !
I can type in pretty much any combination of numbers in C4 and C6 as
long as the sum comes to 28853.09 and my C32 formula works BUT if I
type in the numbers shown above in C4 and C6 my formula fails yet the
sum is EXACTLY THE SAME !!!

Any help anyone can give on this is greatly appreciated.

Thanks.


--
ddelong
------------------------------------------------------------------------
ddelong's Profile: http://www.excelforum.com/member.php...o&userid=25045
View this thread: http://www.excelforum.com/showthread...hreadid=385677