Since the formula still gives the correct result I went
and clicked on "Ignore Error". I am just checking if this
would be an acceptable practice or is there something
underlying I should know about. According to the help, it
says that if an adjacent formula is different than the one
with the issue, you will get an error notification.


-----Original Message-----
Greetings,

In Excel 97 I had this formula in cell D12
=IF(C12<"",IF(B120,C12/B12,0),"")

In cells C12 and B12 I had this:
=SUM(C6:C11)
=SUM(B6:B11)

In Excel 2002 even if I place some numbers in B6:B11 and
C6:C11 I get an Inconsistent formula message. How can I
modify the formula above to make it consistent?

Thanks,
Ben

.