Multiple Formulas in One Cell:Cells, Depend on Other Cell Input

[excelnovice12]

I'm one step away from completing my form. It is an interactive form as in you enter in specific numbers in cells and a price and a part number will develop. I need with the last part because a couple of choices hinder upon the selction of other choices. I have been trying to figure out this last part for the last couple of days. I would attach the sample I am working on, however I cannot at the moment so I'll try to explain.

Here's my problem: There are 3 selections to choose from. Each selections has 4 levels you can choose from that product. if you choose one of the three products, you will get charged standard price. If you pick a combo, you pay standard price for one and a discounted price for the other(s). so if 2 of the three selections are "x", normal prices would apply. if one or none of the selections are x standard price one selection, discounted price for the others.



The VLOOKUPs are A: the standard price for each selection based on the size of the product

1=$10,000
2=$20,000
3=$30,000
4=$40,000

VLOOKUP B: If you pick a combo the discounted cost for the second or third selection

1=$5,000
2=$10,000
3=$15,000
4=$20,000
so if 2 of the three selections are "x", normal prices would apply. if one or none of the selections are x standard price one selection, discounted price for the others.

The first cell has this formula:=IF(H25>=1,(IF(H25="x",VLOOKUP(B25,Sheet3!E2:F6,2,FALSE),VLOOKUP(B25,Sheet3!E2:F6,2,FALSE))))

The second cell has this formula: =IF(B25>=1,(IF(B25="x",VLOOKUP(E25,Sheet3!E9:F13,2,FALSE),VLOOKUP(E25,Sheet3!I9:J13,2,FALSE))))

The final cell has this formula: =IF(E25>=1,(IF(E25="x",VLOOKUP(H25,Sheet3!E16:F20,2,FALSE),VLOOKUP(H25,Sheet3!I16:J20,2,FALSE))))

These formulas connect H25 to B25, B25 to E25, and E25 to H25,
How can I connect B25 to H25?