row 1 headings
a2 0
b2 0
c2 3
d2 =C2+B2-A2 formula
similarly
a3 2
formula b3 =D2
c3 1
d3 (when you drag down d2 , d3 becomes =C3+B3-A3
now take cursor to right bottom of D2 it will turn into +
drag this down
similarly drag B3 down.
is this ok for you
=============================
Mostropovich wrote in message
...
I would like to create/find a spreadsheet with formulas that does the
following:
1) start with: input Sales=0, automatic OpeningStock=0, input Order=3,
automatic ClosingStock=3
2) next time: input Sales=2, automatic OpeningStock=ClosingStock of
previous
session=3, input Order=1, automatic ClosingStock=2
and so on.
Can anybody help please?
|