Separating Positive and Negative numbers and add Running Balance column

roblem:

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
Separating Positive and Negative numbers and add Running Balance column

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube