When this formula is copied down column G, it will continue to calculate a running balance in each row.

Dealing with blank values

To display nothing in the balance column when the credit and debit columns are empty, you can use the IF function with AND and ISBLANK like this: This formula will return an empty string ("") when both credit and debit cells are empty, and returns the running balance if either number exists. Note: this only handles bank credit and debit values at the end of the table, not rows in between.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.