You should be getting a "Too many arguments" message. If are getting a
circular reference then you must have the formula in one of the referenced
cells.

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"aileen" wrote in message
...
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.