#VALUE Error should be simple fix

[Mykull]

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.

 

[dlw]

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]

Thanks...0 will not work. An IF statement may work but I don't know how to
put it all together. I've tried several ways nothing yet.

 

[Don Guillett]

Try putting 662.26 in j1 and then in j2 copied down
=IF(I2>0,j1-I2,"")

 

[Mykull]

I tried this =IF(AND(ISBLANK(I2)),"",662.26-I2)
I still get the same #VALUE errors.