Explanation
The value in G5 is hard-coded. The formula picks up the value in G5, then subtracts the value (if any) in E6 and adds the value (if any) in F6. When the credit or debit values are empty, they behave like zero and have no effect on the result.
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:
=IF(AND(ISBLANK(E6),ISBLANK(F6)),"",G5-E6+F6)
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.
Related functions
IF Function
The Excel IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions. The IF function can be combined with logical...
AND Function
The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0,A1<10). The AND function can be used as the logical test inside the IF...
ISBLANK Function
The Excel ISBLANK function returns TRUE when a cell is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE.
