Multiple IF statements with Variables

[thelsleyjr]

Trying to do the following.

If B12 = "#3 Ham & Cheese" and C12 = "Regular", then J12 = 6.65
If B12 = "#3 Ham & Cheese" and C12 = "Mini", then J12 = 5.55
If B12 = "#7 Turkey & Cheese" and C12 = "Regular", then J12 = 7.65
If B12 = "#7 Turkey & Cheese" and C12 = "Mini", then J12 = 5.75

There are additional arguments but this should get me started.

 

[AhoyNC]

Instead of using a bunch of IF statements you might be better off making a list and then using an INDEX function like in the example below.
I also showed a way to use nested IFs.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
5					List
6					#3 Ham & Cheese	Regular	6.65
7					#3 Ham & Cheese	Mini	5.55
8					#7 Turkey & Cheese	Regular	7.65
9					#7 Turkey & Cheese	Mini	5.75
10
11
12		#7 Turkey & Cheese	Regular							7.65
13
14										7.65
Sheet

 

[thelsleyjr]

My only concern with that is how user friendly it appears. It will be accessible to a lot of people and I want them to be able to select a sandwich and size and know the total. Id have to mess with that more, as I'm less familiar. The old way was, all of the variety sandwiches were priced the same, so the only difference was size. This was the formula. =IF(C12="Regular","7.00",IF(C12="Mini","5.00",0))+IF(I12="",0,LOOKUP(I12,{"Lays","BBQ","Doritos"},{1,1,1}))

 

[AhoyNC]

Another way with a list would be to use SUMPRODUCT.
You could put the list on another Worksheet. The advantage of a list is it would be easy to update pricing. You could make B12 and C12 drop down lists to choose from.

Excel Workbook
	A	B	C	D	E	F	G
5					List
6					#3 Ham & Cheese	Regular	6.65
7					#3 Ham & Cheese	Mini	5.55
8					#7 Turkey & Cheese	Regular	7.65
9					#7 Turkey & Cheese	Mini	5.75
10
11
12		#3 Ham & Cheese	Regular			6.65
Sheet

 

[Fluff]

Another option using a lookup table

Book1
	A	B	C	D	E	F	G
1					List
2					#3 Ham & Cheese	Regular	6.65
3					#3 Ham & Cheese	Mini	5.55
4					#7 Turkey & Cheese	Regular	7.65
5					#7 Turkey & Cheese	Mini	5.75
6
7
8		#3 Ham & Cheese	mini			5.55
RC

Cell Formulas
Range	Formula
F8	=INDEX(G2:G5,MATCH(B8&"|"&C8,INDEX(E2:E5&"|"&F2:F5,0),0))