M
MABeatty
I need to do a circual reference formula.
Basically
A1 = A1+B1
How can I do it?
Basically
A1 = A1+B1
How can I do it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
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"
message
news:[email protected]...
Options, then the Calculation tab. There, check the Iteration
checkbox.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"MABeatty"
message
news:[email protected]...
A
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]...
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]...
C
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
Iterations setting to 1.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com