Hi,

I have a cell where if the cell is empty (A1=0), then I would like the
cell to display "Enter your value here." Otherwise, I would like the
cell to display the value a person enters.

I have tried using an if/then/else statement and, understandably, I
get a circular reference error:

=IF(A1=0,"Enter your value here",A1)

Does anyone have a suggestion?

Thanks!