| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a formula to change data result weekly.
I have a column of dates (I4:I30) with a column next to it for data that has
a new number in it weekly (J4:J30) for 26 weeks that is deducted from a constant. I then have the result in J2. I can manually change the formula in J2 weekly to have that weeks current result, but want to have it change automatically when the weekly number is input in J4:J30. I'm sure there has to be a way to do this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
| how do I change time data to numerical result | Excel Discussion (Misc queries) | |||
| Protect the formula but change result. | Excel Worksheet Functions | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Threaded Mode
