(3) Dropdown list to equal $

Ash213

New Member
Joined
Jul 9, 2019
Messages
2
Greetings, is it possible to have (3) dropdown lists equal a dollar amount?

Task at Hand: I will try to simplify to help make sense. Let's use a restaurant menu as an example.
Depending on your order and the options chosen, the total will be different.

Dropdown list 1: Types of meat-Chicken or Steak
Dropdown list 2: Cooked types-Raw, Rare, Burnt
Dropdown list 3: Types of Sauces- Ranch, BBQ

The grand total for your meal will be different depending on what choices you make.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Welcome to the Board.

Depending on your situation, there are lots of ways to do this. If your 3 dropdowns are in A1, B1, and C1, then you could have a formula in D1 with the dollar amount. The formula could be as simple as:

=IF(A1="Chicken",10,15)+IF(B1="Raw",0,IF(B1="Rare",1,2))+IF(C1="Ranch",1,2)

You'd probably want to put the amounts in look-up tables though, just for ease of maintenance.

If you have a more complicated set-up, that's possible too. For example, if A1 is chicken or steak, and you can order salad or vegetables with chicken, or you can order fries or a baked potato with steak, you can set it up so that the B1 dropdown only shows the right options based on A1. And the formula in D1 would be able to figure out the cost accordingly. You just need to be a bit more specific in what you ask.
 
Last edited:
Upvote 0
Welcome to the Board.

Depending on your situation, there are lots of ways to do this. If your 3 dropdowns are in A1, B1, and C1, then you could have a formula in D1 with the dollar amount. The formula could be as simple as:

=IF(A1="Chicken",10,15)+IF(B1="Raw",0,IF(B1="Rare",1,2))+IF(C1="Ranch",1,2)

You'd probably want to put the amounts in look-up tables though, just for ease of maintenance.

If you have a more complicated set-up, that's possible too. For example, if A1 is chicken or steak, and you can order salad or vegetables with chicken, or you can order fries or a baked potato with steak, you can set it up so that the B1 dropdown only shows the right options based on A1. And the formula in D1 would be able to figure out the cost accordingly. You just need to be a bit more specific in what you ask.

Thank you for the quick reply!
Fortunately it does not get any more complicated BUT what if they choose Steak, raw, ranch or chicken, burned,bbq and etc. Im guessing I would need to expand on the IF,THEN formula? Ultimately I would like (1) grand total cell for all variations
 
Upvote 0
It all depends on your situation. Consider:

ABCDEFGHIJKLM
ChickenBurnedBBQChickenChickenRawRanch
SteakChickenRawBBQ
ChickenRareRanch
RawChickenRareBBQ
RareChickenBurnedRanch
BurnedChickenBurnedBBQ
SteakRawRanch
RanchSteakRawBBQ
BBQSteakRareRanch
SteakRareBBQ
SteakBurnedRanch
SteakBurnedBBQ

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"][/TD]

[TD="align: right"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]5[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]6[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]7[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]8[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0.6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]9[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]11[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]12[/TD]

</tbody>
Sheet3



If the 3 dropdowns are all independent, you could have a lookup for each one to get the price and sum them up. You'd get the price for chicken from G1, for burned from G6, and BBQ from G10, then add them up.

If the prices are dependent on each other, you could have a combined table with all the combinations and the associated cost, then look that up. Row 6 in this case. You just need to design your layout to figure out what formula/setup works best for you.
 
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,187
Members
452,616
Latest member
intern444

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
Back
Top