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
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.
