Excel Spreadsheet

Highlighted
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