Hi.
I'm building a model that allows you to adjust Data Validation lists to display different outputs.
This includes adjusting the Project name (A-D), the scenario based on risk (1-3), and then applies specific growth rates based on those inputs
I would like to make an adjustment that allows me to adjust the launch month (as seen in the table below in column C). If I were to adjust the month to "Jan", I want the formula to apply the 0.1% growth rate to all of 2018, however if I adjust it back to "Jun" I want the formula to automatically zero January-May and apply the growth rate in June and every month after that in 2018.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Scenario[/TD]
[TD]4[/TD]
[TD]2018[/TD]
[TD]2019[/TD]
[TD]2020[/TD]
[TD]2021[/TD]
[TD]2022[/TD]
[/TR]
[TR]
[TD]Launch Timing[/TD]
[TD][/TD]
[TD]Jun[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Growth[/TD]
[TD][/TD]
[TD]0.1%[/TD]
[TD]0.5%[/TD]
[TD]1%[/TD]
[TD]2%[/TD]
[TD]3%[/TD]
[/TR]
</tbody>[/TABLE]
Let me know if you need more information!
Thanks,
Dan
I'm building a model that allows you to adjust Data Validation lists to display different outputs.
This includes adjusting the Project name (A-D), the scenario based on risk (1-3), and then applies specific growth rates based on those inputs
I would like to make an adjustment that allows me to adjust the launch month (as seen in the table below in column C). If I were to adjust the month to "Jan", I want the formula to apply the 0.1% growth rate to all of 2018, however if I adjust it back to "Jun" I want the formula to automatically zero January-May and apply the growth rate in June and every month after that in 2018.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Scenario[/TD]
[TD]4[/TD]
[TD]2018[/TD]
[TD]2019[/TD]
[TD]2020[/TD]
[TD]2021[/TD]
[TD]2022[/TD]
[/TR]
[TR]
[TD]Launch Timing[/TD]
[TD][/TD]
[TD]Jun[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Growth[/TD]
[TD][/TD]
[TD]0.1%[/TD]
[TD]0.5%[/TD]
[TD]1%[/TD]
[TD]2%[/TD]
[TD]3%[/TD]
[/TR]
</tbody>[/TABLE]
Let me know if you need more information!
Thanks,
Dan