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

Attached Files

sample1.xls (29.0 KB, 10 views)

Cross posted on Excelforum

Please read this

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I "crossed-post" because no one can accurately answer my question and since I was on another site I figured someone could answer it. But obviously no one can. Instead you keep telling me that I cross-posted. I understand there are rules...however if you noticed, I started the second thread on a different site hours after no one replied on the previous one...thanks for nothing.