Referencing multiple values in a drop down list, using an 'If' statement

[jwang23]

Hi, I'm trying to build multiple scenarios in excel, using a combination of drop down menus (Created through data validation -> Lists ->Selecting a range of numbers 1-5) and a market model. The list links to a series of values (i.e. 25% market share links to scenario 1, 20% to scenario 2, etc...)

Some of my scenarios have the same value (i.e. 1 and 3 have 25% or 2, 4 have 20%). I'd like to be able to create an if statement that captures this. I tried = if(Reference cell = 4, 20%, 25%) and was able to get the formula to work. However when I tried if(Reference cell = 2 or 4, 20%, 25%) I got an error. Any tips on correcting my mistake?

Thanks!

[AliGW]

Welcome to the forum!

Which Office product do you have? I presume Office 365, as there is no 360 version.

Try this:

=IF(OR(Reference cell = 2,Reference cell = 4), 20%, 25%)

[jomaor1]

Could you elaborate more, or just post an example workbook?

If I'm understanding it right, you could use Combo Boxes to create that.