You shouldn't have a cirular reference. If the table is in columns A:C with
the header in row 1 and the first data in row 2 then:
A2 should have the starting inventory, B2 the first change (both are fixed
values) and C2 should have the calculated new inventory: =A2+B2.
In row three, the 'previous inventory' should be the prior row's 'new
inventory.' So in A3, =C2. B3 has the next update. And C3 is calculated
again as previous inventory + change: =A3+B3.
Now you should be able to copy the formulas from row 3 down to each new row,
only filling in the +/- in column B of each row, and with no circular
references.


"maintchief" wrote:

My wife is a hotel breakfast hostess. Her boss wants her to keep a weekly
inventory of breakfast food items. In trying to EXCEL it I run into a
problem.
Three columns: Previous Inventory, Additions/Subtractions(+/-), New Inventory.

If I add +/- to Previous Inventory to get New Inventory I get a circular
reference problem.
To avoid this I figure she will have to input Previous Inventory (manually)
from New Inventory and then input +/- to get a 'new' New Inventory. Is there
a way to avoid the double manual input and avoid the circular reference
problem?