just put a 0 in the I column, if not that, you have to put an IF statement in
the formula to check to see if there is a value in I

"Mykull" wrote:

F G H I J
Expense Date Amt Cumulative Whats Left
2 Gas 05/01/09 $21.26 $21.26 $641.00
3 Cash 05/04/09 $102.00 $123.26 $539.00
4 Gas 05/04/09 $24.74 $148.00 $514.26
5 #VALUE!
6 #VALUE!



The formula I have in J2 is simply 662.26-I2
The long version = I just want column J to continuously subtract the column
I starting with 662.26 as a balance. Its working fine I just want get rid of
the #VALUE that is displayed all the way down the page in column J.