Can I change a cell and cause an automatic change in other cells

S

Swissmiss

Is there a function or formula that will allow me to make a change in one
cell on the work sheet and the program will automatically change one or more
designated cells with that same change?
 
A

Anne Troy

Please describe the exact scenario. I'm sure we could be much more helpful
that way. :) Formulas will automatically change other cells, so your
question seems odd.
************
Anne Troy
www.OfficeArticles.com
 
S

swatsp0p

Simply refer to that cell in your other "designated" cells, as such:

If A1 is your base cell, in another cell enter =A1

When you change the value in A1, it will change in your other cell t
show what is in A1

You could perform math functions as such: =25-A1
If you enter 10 in A1, your cell will show 15
change A1 to 20 and your cell will now show 5

HTH

Bruc
 
Top