A basic
running balance formula can lead to hard - to - detect errors.
In this article, I'll explain the problems with the basic
running balance formula and provide two robust solutions.
Not exact matches
In fact, the
running balance is wrong in both rows 2 and 3, because the
formulas are not referencing the correct previous
balance.
Although not necessary for making a robust
running balance, you might be interested in making your
formula even more readable, as shown in the image below.