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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,129,713
Messages
5,637,936
Members
416,993
Latest member
ant8989

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