Thread: circular reference error for simple IF statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aileen aileen is offline
external usenet poster
  
Posts: 78
Default circular reference error for simple IF statement
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.


Reply With QuoteReply With Quote