Assigning a number to a dropdown list

**OlSchool** · 02-25-2013, 11:46 AM

Hi Guys

This seems a bit difficult...

I need to assign a point to the following products if selected from cell C6:E6

If "Rewards" is selected its 5 points
If "Consent" is selected its 3 points
If "Notify Me" is selected its 1 point

But theres a twist to this. If all 3 cells are selected with Rewards, Consent and Notify Me, bonus points are awarded which is 15 points. It will no longer be 9 points.

If only 2 products is selected it will be the points awarded to those 2 products plus bonus points of 5, so if Rewards(5) and Consent(3) is selected the total points will be 13.

Hope im making sense.

I have attached a workbook.

**martindwilson** · 02-25-2013, 02:44 PM

can you select the same option more than once?, there is no "blank"option

**K m** · 02-25-2013, 03:28 PM

Try this formula in cell F6:

Please Login or Register  to view this content.

See Attached

**OlSchool** · 02-27-2013, 02:48 AM

Thanks K m, it works perfectly! However, i made a mistake with the scenario given. I Said 'If only 2 products are selected it will be the points awarded to those 2 products plus bonus points of 5, so if Rewards(5) and Consent(3) is selected the total points will be 13'. It supposed to be if only "rewards" and "Consent' is selected, then bonus points are awarded.