bobgrand
Board Regular
- Joined
- Apr 14, 2008
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
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
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
Last edited by a moderator: