How do I add to one cell and auto subtract from another in Excel?

A

Al

I want to track vacation days: taken and left to take. How do I link two
cells so when I add to one the other automatically subtracts the same value?
 
S

Stephen

Al said:
I want to track vacation days: taken and left to take. How do I link two
cells so when I add to one the other automatically subtracts the same
value?
Click to expand...

Let's say you start with 25 days leave available and you want to put the
number of days taken into A1. In the cell where you want the number of days
remaining put the formula
=25-A1
 
D

DNA

Here's what I would do:

In say A1, have total available days.

In say B1, have days taken.

In say C1 put =SUM(A1-B1), this will give number of days left to take or
display a negative number if the person has taken more than allowed from
A1.

HTH
 
Top