How do I add to one cell and auto subtract from another in Excel?
"Al" wrote in message
...
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?
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
|