» Separating Positive and Negative numbers and add Running Balance column

Problem:

One column contains mixed values of positive and negative numbers, needs to be
Separated into two columns, in the first column positive values in second column negative values.
Finally, add a formula to return running balance along the cells in a third column.

Solution:

Steps 1- Into cell B2 enter the formula:
=IF($A2>=0,$A2,"") and then copy the formula down to all cells in the range of data of column A.

Steps 2- Into cell C2 enter the formula: =IF($B2="",$A2,"") and again copy the formula down.

Steps 3- Into cell D2 enter the formula: =SUM(A2:B2).

Step 4- Into cell D3 enter the formula:=D2+SUM(A3:A3) and copy the formula down the remainder of the range.
Screenshot // Separating Positive and Negative numbers and add Running Balance column