Search code examples
excelsubtraction

Function for subtracting a value from one cell also subtracts that value from another cell

Example:

Credit Debt = 200

Bank = 500

Subtract 100 from Credit Debt will also subtract 100 from Bank

Credit Debt = 200 - 100

Bank = 400

Please let me know if this is possible. Thank you!

Solution

  • Place the credit amount in A1 and the bank amount in A2.
    Place the value to be subtracted in A3.

    Then in B1 enter:

    =A1-A3

    for the reduced credit and in B2 enter:

    =A2-A3

    for the reduced bank amount.