Hi Naomi hope this will answer your question:

Go to 'Tools', then select 'Options', then select 'Calculation',
Then tic 'Iteration' and write a number of maximum iterations you would
like. This will allow a cell to calculate itself.

regards
Albert

"Naomi" wrote:

I want a cell to display a word if its contents is "0", but whenever i apply
an "if" statement to that cell, it reads itself and returns a circular ref!
How can I apply a formula to the same cell it rests in, and then use that
same formula going down a range? I think the answer will smack me in the
head when I see it posted.
thanks!