A conditional expression is neccessary, I think?
Office 365 home--
Problem:
If I enter a + value in either the Increase, col K or the Decrease, col M I want the running Balance in col O to automatically, properly adjust to the revised balance.
Solution ?
Although I've never used the process before, I think the solution requires using a conditional phrase/formula in the Balance O col cells.
Such that the conditional formula would see an entry in col K and add the value to the Balance col. Or, on the other hand, if the conditional formula sees an entry in col M it would subtract the value from the Balance col.
I'm attaching the spreadsheet in question.
Would someone be good enough to provide the formula that I'm looking for along with a link that explains usage?
Mark
|