Excel Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1545879%22%20slang%3D%22en-US%22%3EExcel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1545879%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20create%20a%20formula%20to%20automatically%20calculate%20my%20ending%20balance%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EBalance%3A%26nbsp%3B%20%26nbsp%3B%20%245%2C599.00%26nbsp%3B%20(This%20field%20has%20formula%20%3DSUM(G9%3AG13)%3C%2FP%3E%3CP%3EDisbursements%3A%26nbsp%3B%20-%24980%3C%2FP%3E%3CP%3EEnding%20Balance%3A%26nbsp%3B%20%26nbsp%3BI%20want%20to%20create%20a%20formula%20here%20that%20takes%20the%20current%20balance%20(%245%2C599.00%20and%20subtracts%20the%20disbursement%20%24980%20to%20give%20me%20my%20new%20balance)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1545879%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

How do I create a formula to automatically calculate my ending balance?

 

Example:

Balance:    $5,599.00  (This field has formula =SUM(G9:G13)

Disbursements:  -$980

Ending Balance:   I want to create a formula here that takes the current balance ($5,599.00 and subtracts the disbursement $980 to give me my new balance)

 

0 Replies