Formula in Excel for stock control records
 

Hi, I am looking for various formulas for a stock control spredsheet.


a1 a2 a3
a4 ref cell
Date Stock In/Out Balance 100(start stock)
1/1/06 -20 need this cell to relate to 80
2/1/6 +20 need this cell to relate to 100 etc