IF drop down Question - Adding launch month & year to product forecast

HarrWi

New Member
Joined
Nov 3, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Background - I am creating a 3 year revenue forecast for a product that is to be launched. The forecast starts with the raw number of customers in each market, and then applies cuts based on assumptions as you move down the model, finally ending with revenue and volume as the output.

Problem - Each market has different launch dates, that may change. As such when we roll out this forecast, to each country team, it would be good if they could select the month and year when they launch, and then the forecast adapt accordingly.

Ideal Solution - I have a drop down list for month and year. if for example, the user selected launch date for March 2021, the following would happen:

1. The customer numbers in 2020 are multiplied by 0 as the product has not launched in this year. Equally the raw customer numbers in 2022 and 2023 are unchanged
2. The customer numbers in 2021 are multiplied by 9/12, as the product launched in March and thus there are 9 months left of the year where they can sell to customers
3. Only the year 2021 is affected

Is this possible?
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,129,974
Messages
5,639,332
Members
417,081
Latest member
Jeyaraj2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top