I'm guessing you have this in either F1, A1 or B1. Alternatively, a formula
in any of those cells ultimately refers to the cell that this formula is in.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"aileen" wrote:

This IF statement is giving me a circular reference error:

=IF(F1="C",A1,0,IF(B1="CALL",A1,0))

Is it possible to get around the fact that the data for the True statement
is in the same field for both IF statements? Or is it something else in this
statement that's causing the error. Thanks for any help.