Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell formula based on input in different cell
Here is a somewhat unique issue. I am dealing with a variable lead
time on an item and the value entered can be 1, 2, 3...etc for how many weeks. The issue is that if the value is 1 then B5=C4. If the value is changed to 2, then I want B5=D4 and so on. Is there anyway to do this? Any help is much appreciated. Thanks, DtTall |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell formula based on input in different cell
Assuming your input cell is A1, enter in B5:
=OFFSET(B4,0,A1) Cheers, -- AP "DtTall" a écrit dans le message de news: ... Here is a somewhat unique issue. I am dealing with a variable lead time on an item and the value entered can be 1, 2, 3...etc for how many weeks. The issue is that if the value is 1 then B5=C4. If the value is changed to 2, then I want B5=D4 and so on. Is there anyway to do this? Any help is much appreciated. Thanks, DtTall |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell formula based on input in different cell
In B5
=CHOOSE(variable_lead_time,C4,D4) just extend as required -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "DtTall" wrote in message ps.com... Here is a somewhat unique issue. I am dealing with a variable lead time on an item and the value entered can be 1, 2, 3...etc for how many weeks. The issue is that if the value is 1 then B5=C4. If the value is changed to 2, then I want B5=D4 and so on. Is there anyway to do this? Any help is much appreciated. Thanks, DtTall |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell formula based on input in different cell
Long time no see!
"Ardus Petus" wrote in message ... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell formula based on input in different cell
Been busy getting paid for my developments!
"Bob Phillips" a écrit dans le message de news: ... Long time no see! "Ardus Petus" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change cell color in excel based on text input? | New Users to Excel | |||
How to change Font size based upon cell input | Excel Discussion (Misc queries) | |||
How do I change the format of a cell based on what I input? | Excel Worksheet Functions | |||
data validation to restrict input in cell based on value of cell above that cell | Excel Programming | |||
Macro to change list box input range based on selection made in another cell | Excel Programming |