Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error using this simple formula | Excel Discussion (Misc queries) | |||
Fix Simple #Div/0! error | Excel Worksheet Functions | |||
Simple Error Dialogue box | Excel Discussion (Misc queries) | |||
error in simple calculation? | Excel Discussion (Misc queries) | |||
Simple #DIV/0! error | Excel Worksheet Functions |