ExcelBanter - How can I link and deduct one cell from a budget in another?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I link and deduct one cell from a budget in another? (https://www.excelbanter.com/excel-worksheet-functions/116193-how-can-i-link-deduct-one-cell-budget-another.html)

stevierobs

How can I link and deduct one cell from a budget in another?

I am trying to create a formula or macro so that I can enter an amount in
one cell and it then automatically reduces the budget amount in another cell.

Dave F

How can I link and deduct one cell from a budget in another?

Assume your budget is calculated in B1

=B1-A1 would do what you're looking to do.

stevierobs wrote:
I am trying to create a formula or macro so that I can enter an amount in
one cell and it then automatically reduces the budget amount in another cell.

All times are GMT +1. The time now is 02:44 AM.