If combo box value =this then this, else?? Anyone?

  • Thread starter Thread starter Fredy
  • Start date Start date
F

Fredy

I'm trying to figure out a formula for the following. I
have an order form where certain products are classified
as one of two categories. THe two categories exist in a
combo box control (not userform or vba). I want o add up
the category total for cat1 and total for cat 2 items and
based on the sums, calculate a delivery and install fee.
Basically, if i have this much worth of cat1 items, charge
this much D&I, if ihave this much, then.........and so
forth. I have everything except how to include the combo
box in the formula. Can anyone help?

thanks,
 
Fredy
One of the properties of a combobox is labeled LinkedCell. You can enter a cell reference here and the value in the combo box will fill in that cell. Then you can reference that cell in your formulas

Another option you might want to consider is Data>Validation. This can be set up to give you a pull down list directly in a cell

Good Luck
Mark Graesse
(e-mail address removed)

----- Fredy wrote: ----

I'm trying to figure out a formula for the following. I
have an order form where certain products are classified
as one of two categories. THe two categories exist in a
combo box control (not userform or vba). I want o add up
the category total for cat1 and total for cat 2 items and
based on the sums, calculate a delivery and install fee.
Basically, if i have this much worth of cat1 items, charge
this much D&I, if ihave this much, then.........and so
forth. I have everything except how to include the combo
box in the formula. Can anyone help?

thanks,
 
Back
Top