Hi all,

Would really appreciate your help!

I have downloaded a bank statement onto excel (numerical values appearing in 3 columns: paid in, paid out, balance) and wish to apply formulas to it - basically, a cumulative summary column alongside.


I have two problems/questions, although the first one is probably irrelevant as the second proposal might eradicate my format problem...(?) I look forward to receiving your replies! This is my first post to any computer forum - a last resort measure to try to address my IT inadequacies!

Thank you so much!!!




1. The basic formula I tried to use is not recognising the cells with no value. If I type in a "zero" then the formula works. If not, the "#VALUE!" error message appears.

What is the best way to correct this? I have tried changing the cell format. It is currency format. In my limited knowledge of excel I think I need to apply a formula: "IF there's a value in the cell, use it, IF NOT, apply a zero" so that I don't have to go down and enter a load of zeros!!!



2. In the whole of the cumulative column, not just cell by cell (for example column D) I would like the following formula but have no idea how to create it:
For example:
In D2: "If there's a value B2, subtract it, if there's a value in C2 add it, if there's no value in either then apply the last value on the last cell with a value in this column"