Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple Circular Reference Problem
This is the first time i am trying to play around with circular reference.
What I am trying to do is..... I am entering a formula in cell A1, The formula is =A1+B1 (very simple) I have already checked the Iteration box and set the maximum iterations to 1. (tools/options/calculation) the formula is working but.....whenever i save it or do anythingin in the sheet..like..delete something, enter a figure in some other cell etc. etc., it adds the last value again. for example - I enter 2 in B1, A1 shows 2, then I enter 3 in B1, A1 shows 5. Now, if do anything in the sheet it will add 3 again and A1 would show 8...if I keep on pressing CTRL+S, it keeps on adding 3 to A1. Can anyone give me the solution to this problem please? Thanks Gary |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference mistake | Excel Worksheet Functions | |||
Circular reference help please! | Excel Discussion (Misc queries) | |||
circular reference (Excel 2000) | Excel Worksheet Functions | |||
Force circular reference | Excel Discussion (Misc queries) | |||
Help solve a Circular Reference | Excel Worksheet Functions |