Positive result, negative result and current balance. How do you make starting balance show current result?

Posted by Tine on Super User See other posts from Super User or by Tine
Published on 2012-12-01T21:02:43Z Indexed on 2012/12/01 23:07 UTC
Read the original article Hit count: 280

I have 3 columns. Column A shows positive result and if the result is negative then it is in a column B. Column B shows negative result and if the result is positive then it is in a column A. (meaning that either columns can have 0.00 in the cell (empty zero cells)).

Column C has starting assets and it also shows the current balance that while result A or B are adding up and current balance is showing the current result. What is the proper formula for this I hope I was clear with my problem. Please help. Thanks in advance!

© Super User or respective owner

Related posts about microsoft-excel

Related posts about excel-2007