I have a very basic expense sheet that I cannot figure out how to calculate the total balance column/cells properly.
<tbody>
</tbody>
I need the balance column to calculate to either add or subtract the Cost/Refund/Deposit amounts. One balance cell should have a formula to let it know to add or subtract depending on which amount is added to the other columns/cells (Cost column will be a subtraction while Refund and Deposit are additions). Make sense? Please help. Thanks!
Date | Client Name | Item Description | Cost | Refund | Deposit | Balance |
3/29/19 | Admin | Call Deposit | $300 | $300 | ||
4/1/19 | Jones | Call Cost | $86 | $214 | ||
4/2/19 | Jones | Call Refund | $86 | $300 | ||
<tbody>
</tbody>
I need the balance column to calculate to either add or subtract the Cost/Refund/Deposit amounts. One balance cell should have a formula to let it know to add or subtract depending on which amount is added to the other columns/cells (Cost column will be a subtraction while Refund and Deposit are additions). Make sense? Please help. Thanks!