 |
 | 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 / General Excel Questions / May 2007Changing a formula
This may be really stupid questions but here it goes... Below is my formula, I am adding some columns then dividing by 3. Next week I will need the same columns added but will need to divide by 4, the follwing week by 5. Is there any way Excel will do this without me manually changing the number each week? =SUM(M13:M16)/3 Put the value in a cell then all you need to do is change that cell and not the formula. A1 = 3 =SUM(M13:M16)/A1 Biff > This may be really stupid questions but here it goes... > Below is my formula, I am adding some columns then dividing by 3. Next [quoted text clipped - 4 lines] > > =SUM(M13:M16)/3 =SUM(M13:M16)/(WEEKNUM(A1)-17) for this week, will work until 01/01/08  SignatureRegards, Peo Sjoblom > This may be really stupid questions but here it goes... > Below is my formula, I am adding some columns then dividing by 3. Next [quoted text clipped - 4 lines] > > =SUM(M13:M16)/3 =SUM(M13:M16)/(WEEKNUM(TODAY())-17) The 17 needs to be adjusted the first time you use it to make sure you get your 3 divisor. Or, you could just type the 3 in a helper cell, say A1, and then you would just change it weekly instead of having to modify the formula(s) =SUM(M13:M16)/A1 Vaya con Dios, Chuck, CABGx3 > This may be really stupid questions but here it goes... > Below is my formula, I am adding some columns then dividing by 3. Next [quoted text clipped - 3 lines] > > =SUM(M13:M16)/3 Replace the week with the following to get a number that increments each week INT((NOW()/7)-5599) > This may be really stupid questions but here it goes... > Below is my formula, I am adding some columns then dividing by 3. Next [quoted text clipped - 3 lines] > > =SUM(M13:M16)/3 |
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.