#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Maybe like the attached.
|
#3
|
|||
|
|||
Precisely what I needed. Thank you!
|
Tags |
conditional_formula |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is MSFT Expression still the current program? | billbowers | Misc | 0 | 08-24-2015 07:43 AM |
VBA code to enable Regular Expression | ronmayerle | Word VBA | 2 | 11-20-2014 01:09 PM |
Microsoft Expression Web | ts6947 | Misc | 0 | 02-22-2013 08:20 AM |
Can pass .expression as a parameter? | tinfanide | PowerPoint | 4 | 12-28-2012 06:14 PM |
Conditional Expression that Moves Data (challenging) | themangoagent | Excel | 1 | 02-20-2010 11:29 AM |