Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
balance sheet problem
Hi,
I am trying to set up a spreadsheet to show my bank account balance I want the 3 number columns to be credit (D column) debit (E column) balance (F column) now I have it working but... if I don't have a value in a debit column it displays #value in the balance column. So I amend the cell formula as follows =IF(E5="","",F4-E5+D5) (IF debit column is empty THEN display blank ELSE display calculation result) but this only checks one column, the debit column if I have a value in the credit column but leave the debit column empty I get the #value error message. I have put a zero in the debit column as a work-around but I would like to fix it more elegantly I tried using the OR function but that didn't work as one of the columns always has a value any help would be appreciated. -- Nospam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic Balance Sheet Problem | Excel Discussion (Misc queries) | |||
balance sheet problem | Excel Programming | |||
balance sheet | New Users to Excel | |||
balance sheet | New Users to Excel | |||
Balance sheet | Excel Discussion (Misc queries) |