This content has been marked as final. Show 3 replies
Here The opening stock in the 1st month is 0 and in the second month (i.e may) is the value of balance in previous month(i.e april) and balance is calculate by formula column(1)+column(2)-column(3)-column(4),
where column(1)= opening stock
column(4) = V3
What should be the expression for the Opening stock(i . e column(1))??
Note: If i select May, the value of opening stock still should remain 2 ,not 0
Any help would be appreciated