I have a value in cel A2 say 10,000 , & in cell B2 to F2 i have months & some values getting a total of 13000 (B2 to F2). I need a forrmula to know the difference between A2 & (B2 to F2) should not go less than zero.. B2 is 2000 ; C2 is 4000 ; D2 is 2000 ; E2 is 4000 ; F2 is 1000 (13000 in total).
If i see the difference its -3000.
But i want a formula that stops by not goin to negative (columns getting added from back)
in sense if i look to the last 3 columns its 7000 & last 4 columns is 11000 (whixh is higher that A2) ...
so i need the diff of 3000 as out put (A2 - sum(D2:F2)
is it possible
Solved by C. C. in 34 mins