If Statements

[BrianK]

I am trying to write a formula that contains 11 IF statements. Excel of course will only allow 7, how can I make this work. Any help would be greatly appreciated.

Thanks a lot

Brian

 

[Norie]

What do you actually want the formula to do?

As far as I know 7 is the limit for IF worksheet functions.

Perhaps there is another way to get the result you want.

 

[BrianK]

I am creating a spreadsheet to give a food cost. When they build a cake they have 11 different ice cream choices to build the cake with and each ice cream of course is a different price. So I am building a food cost for each cake, and depending on what they select for the ice cream that is the price that I need to put into the food cost breakdown.

Now that I think about it there are 35 cake choices so in order to decide the food cost for a cake that is chosen, I will face the same problem here.

Hope that makes sense??

 

[Andy128]

Brian-
I had a similar problem where there were more choices to be decided than if statements allowed. I wound up making a seperate table for my choices and then used a vlookup formula to match the item to the table. Look into the vlookup function. I now use it more than the if function.

Good luck- Andy

 

[Scott Huish]

Here is an example with VLOOKUP:

Formula in C3:
=VLOOKUP(A3,$E$2:$F$7,2,0)+VLOOKUP(B3,$H$2:$I$10,2,0)

Book1
	A	B	C	D	E	F	G	H	I
1					CakeFlavor	Price		IceCreamFlavor	Price
2	CakeFlavor	IceCreamFlavor	Price		White	$12.00		Vanilla	3.99
3	White	Chocolate	$16.99		Chocolate	$14.00		Chocolate	4.99
4	Chocolate	RockyRoad	$19.99		Yellow	$12.00		Strawberry	4.99
5	Yellow	ButterBrickle	$18.99		Spice	$12.50		FrenchVanilla	6.99
6					Lemon	$14.00		RockyRoad	5.99
7					Orange	$10.00		ButterBrickle	6.99
8								Pistachio	2.99
9								ChocolateChip	4.99
10								ChocolateChipMint	4.99
11								OrangeSherbet	2.99
Sheet1