M
Martin ©¿©¬
Hi
I have a small spreadsheet for income which I input relating to date
using
=IF($A3<=TODAY(),166.24,"")
&
=IF($A4<=TODAY(),500,"")
I then manually insert withdrawals & calculate the balance.
How would I create a formula that calculates the balance by date?
A C E G I
Date In In Withdrawn Balance
£30.11
01/03/2012 166.24 £196.35
07/03/2012 500.00 £696.35
I have a small spreadsheet for income which I input relating to date
using
=IF($A3<=TODAY(),166.24,"")
&
=IF($A4<=TODAY(),500,"")
I then manually insert withdrawals & calculate the balance.
How would I create a formula that calculates the balance by date?
A C E G I
Date In In Withdrawn Balance
£30.11
01/03/2012 166.24 £196.35
07/03/2012 500.00 £696.35