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.
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.