Circualr formula

[MABeatty]

I need to do a circual reference formula.

Basically
A1 = A1+B1

How can I do it?

[Chip Pearson]

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"
<[email protected]> wrote in
message
news:[email protected]...
>
> 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
>

[Ardus Petus]

Do you mean:
whatever quantity you enter in A1, you want it added with B1's value?

--
AP

"MABeatty" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> 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
>

[Chip Pearson]

I should have added that you'll want to set the Maximum
Iterations setting to 1.


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


"Chip Pearson" <[email protected]> wrote in message
news:%[email protected]...
> 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"
> <[email protected]> wrote
> in message
> news:[email protected]...
>>
>> 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
>>
>
>