Receiving circular reference when referring to another cell

[Preacherman771]

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?

 

[Michael M]

You shouldn't get a circular reference error....unless yo are putting it the wrong cell, ie B23. The formula works fine for me

 

[Michael M]

A thought.....A23 and B23 aren't merged cells are they ??

 

[Preacherman771]

Thanks for the quick response. After reading your link, I checked the array in B23, and found among all of it a single reference to A23 and deleted it. It now works fine. Thank you for the help.

 

[Michael M]

Glad you solved it...