 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2005Can I change a cell and cause an automatic change in other cells
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? 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 > 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? 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 -- swatsp0 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.