Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
assigning values to one cell which will change the formula in anot
Does anyone know if it is possible to assign a value to a number, say 1, that
when entered into a cell it will automatically change the formula in corresponding cells. EG. If 1 = +10days I enter 1 in b3, then the formual in b5 will change from +20days, to +10days etc. I don't even know if this is possible with excel, but would very much appreciate any feedback possible. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
assigning values to one cell which will change the formula in anot
I don't think it is possible to assign a value to a number, you can only
assign a value to a cell. Also, your example refers to 2 cells, B3 and B5, is it a typo? However, why not use some available features of Excel, like using named ranges? Go to cell B3, then on the formula bar, on the left where B3 is written, click it and put for example AddDays. Now, in your cell where you would like to use the content of this cell, simply add at the end of the formula +AddDays. If this is not what you want, let us know! Stephane. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning point values? | Excel Worksheet Functions | |||
Assigning cell values to return a number | Excel Discussion (Misc queries) | |||
Assigning cell values to return a number | Excel Discussion (Misc queries) | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) |