Use the formula you have. Then, go to the Tools menu, choose
Options, then the Calculation tab. There, check the Iteration
checkbox.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"MABeatty"
wrote in
message
...

I need to do a circual reference formula.

Basically
A1 = A1+B1

How can I do it?


--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile:
http://www.excelforum.com/member.php...o&userid=32258
View this thread:
http://www.excelforum.com/showthread...hreadid=525665