How to Use Drop Down Results to Add Multipliers to Existing Sums

Good Afternoon!

Thank you kindly for all the work you do on this forum. It has definitely come in handy in learning, although I am still on the basics.

I am looking to use some drop down text results to apply some multipliers to some computer disk space numbers.

There would be a starting number, likely calculated from some previous sums. Then, basically the user should select one of three options from a dropdown. The values of the dropdown would be listed in another sheet. If they pick Option A then the number stays the same. If they select Option B then the number gets multiplied by 1.5. If they take Option C then it gets multiplied by 2.5.

Then it would place the answer in another cell. I would like to do this in a few drop downs so I imagine if you could show me your thoughts for one or two rows, I can repeat the process for others.

I've attached a sample workbook, any suggestions would be appreciated. In the sample, I've created a few rows that have drop boxes (with the values on another sheet) and then the cells where the numbers should ideally be displayed.

Thank you in advance,

*Edit* Also little typo in the sample workbook, E10 should read E7

Assuming I understand correctly, here's one possibility:

1) Get multiplier from first option. In E7 =IF(B7="uhd4k",1.5,1)
2) Get multiplier from second option. In E10 =IF(B10="25 fps",2.5,1)
2a) additional multipliers from other options as noted. Note that using a simple IF() function assumes that there are only 2 choices for each option. If any option has more than 2 options, I would be tempted to use a lookup function rather than an IF() function.
3) The final result (again, assuming I am understanding correctly) is a simple PRODUCT() function =PRODUCT(E5:E10). Note that you cannot enter any stray numbers in the blank cells in this range, or they will be included in the multiplication. Note that this means that the choosing both options means the final result would be 103.8*1.5*2.5=103.8*3.75=389.25

E7:
=if(b7="uhd4k",1.5,1)*e5

e10
=if(b10="10 fps",1,2.5)*e7

b18:
=e10

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.