#VALUE Error should be simple fix
 

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.

#VALUE Error should be simple fix
 

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.

#VALUE Error should be simple fix
 

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.


"dlw" wrote:

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.

#VALUE Error should be simple fix
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mykull" wrote in message
...
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.

#VALUE Error should be simple fix
 

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



"dlw" wrote:

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.