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. |
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 |