Preacherman771
New Member
- Joined
- Jun 15, 2021
- Messages
- 46
- Office Version
- 365
- Platform
- Windows
I am trying to create an if statement to check the cell in the same row but next column, e.g, typing in A23 "=if(B23<>"---","--","*")". I will receive a circular reference error each time. When trying to trace the error, the Circular Referencing is grayed out and Trace error will return no error found. Why am I receiving the message and what is the solution?