Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing a formula
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 "Donnas" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing a formula
=SUM(M13:M16)/(WEEKNUM(A1)-17)
for this week, will work until 01/01/08 -- Regards, Peo Sjoblom "Donnas" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing a formula
=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 "Donnas" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing a formula
Replace the week with the following to get a number that increments each
week INT((NOW()/7)-5599) Donnas wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to edit formula without changing formula of each cell | Excel Worksheet Functions | |||
Changing Formula | Excel Discussion (Misc queries) | |||
Changing formula to a value | Excel Worksheet Functions | |||
Changing a Formula | Excel Worksheet Functions | |||
Copy Formula Down Without Changing Entire Formula | Excel Discussion (Misc queries) |