Returning multiple values based on multiple parameters

[thelsleyjr]

Please help! I am struggling so bad!

I am trying to run 4 potential values.

C11 can contain "Mini" or "Regular"
Mini = 5.50
Regular = 6.50

BUT

If H11 contains "Lays","BBQ","Doritos", then add .50 to total.

So if they select one of those options, the total then becomes 6.00 for a Mini & Chip, or 7.00 for Regular & Chip


Here's what I have so far... =IF(C11="Regular","6.50",IF(C11="Mini","5.50")) But I can't seem how to work it in to add the .50 if they add chips to either option.

If this would let me add a photo I would share but I can't seem to figure that out.

 

[Fluff]

Hi & welcome to MrExcel.
Where do the chips come into it?

 

[Fluff]

Assuming you meant H11 could be Chips rather than Lays, try
=IFERROR(LOOKUP(C11,{"Mini","Regular"},{5.5,6.5})+IF(OR(H11={"Chips","BBQ","Doritos"}),0.5,0),"")

 

[JoeMo]

Assuming any of the 3 brands of chips add $0.50:

=IF(C11="Regular","6.50",IF(C11="Mini","5.50",0))+IF(H11="",0,LOOKUP(H11,{"Lays","BBQ","Doritos"},{0.5,0.5,0.5}))