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.
<tbody>
</tbody>
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.
Scenario | 4 | 2018 | 2019 | 2020 | 2021 | 2022 |
Launch Timing | Jun | |||||
Growth | 0.1% | 0.5% | 1% | 2% | 3% |
<tbody>
</tbody>
Let me know if you need more information!
Thanks,
Dan