D

#### ddelong

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.