| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
