ExcelBanter - Circualr formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Circualr formula (https://www.excelbanter.com/excel-discussion-misc-queries/79159-circualr-formula.html)

MABeatty

Circualr formula

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

Circualr formula

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

Ardus Petus

Circualr formula

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

--
AP

"MABeatty" a écrit
dans le message de
...

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

Circualr formula

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" wrote in message
...
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

All times are GMT +1. The time now is 07:46 AM.