(3) Dropdown list to equal $

[Ash213]

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.

 

[Eric W]

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.

 

[Ash213]

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

 

[Eric W]

It all depends on your situation. Consider:

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Chicken	Burned	BBQ	6		Chicken	5			Chicken	Raw	Ranch	1
2						Steak	10			Chicken	Raw	BBQ	2
3										Chicken	Rare	Ranch	3
4						Raw	1			Chicken	Rare	BBQ	4
5						Rare	2			Chicken	Burned	Ranch	5
6						Burned	0.4			Chicken	Burned	BBQ	6
7										Steak	Raw	Ranch	7
8						Ranch	0.7			Steak	Raw	BBQ	8
9						BBQ	0.6			Steak	Rare	Ranch	9
10										Steak	Rare	BBQ	10
11										Steak	Burned	Ranch	11
12										Steak	Burned	BBQ	12

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</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.