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 have attached the sample I am working on.
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.
How can I connect B25 to H25?
Disregard the numbers from N27 on.
http://www.excelforum.com/excel-form...html?p=3034379