Circular Reference Error

[bobgrand]

Hello all,

The following 2 formulas are giving me a Circular Reference Error and I can't figure out why. I can really use some extra eye's on this to help me figure out why. Any help as always is greatly appreciated.

This formula is in P12 - =IF(OR(I12="N",Q12=""),"I",IF(N12="YES","U","A"))
This formula is in Q12 - =IF(P12="U","",IF(AND(D12="I",O12<>""),"IA",IF(AND(D12="C",N12<>""),"MA",IF(AND(D12="D",N12<>""),"DA",""))))

The final circular arrows are pointing to P & Q

If there are other formulas needed from other columns please let me know an I will post them

 

[Joe4]

Your formula in cell P12 is using Q12 in its calculation.
And your formula in Q12 is using P12 in its calculation.

So they are fighting with each other. Each is trying to adjust the value based on the other.