How do I use a combo box in a formula

[Emma]

Hi,
I have a combo box with:
No discount
50% discount
55% discount
60% discount
65% discount

I want to then automatically have the total cell "P13"
calculate what the total cost would be with the discount
included.
So if the total cost was £100 and the combo box was
showing 50% I want the "P13" cell to calulate so it show
£50.
Is this possible?
I created the combobox just by using the forms button.
Emma

 

[NickHK]

Emma,
To make it more easy for you, why not have 0, 50, 55...as your combo box
value.
Then set the box's Linked Cell property to say D4

Then it's a case of Total=Sum prices*0.?discount.

NickHK

Hi,
I have a combo box with:
No discount
50% discount
55% discount
60% discount
65% discount

I want to then automatically have the total cell "P13"
calculate what the total cost would be with the discount
included.
So if the total cost was £100 and the combo box was
showing 50% I want the "P13" cell to calulate so it show
£50.
Is this possible?
I created the combobox just by using the forms button.
Emma

 

[Bob Phillips]

Emma,

Why not use Data Validation, the result is in the cell so you can pick it
up from there.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi,
I have a combo box with:
No discount
50% discount
55% discount
60% discount
65% discount

I want to then automatically have the total cell "P13"
calculate what the total cost would be with the discount
included.
So if the total cost was £100 and the combo box was
showing 50% I want the "P13" cell to calulate so it show
£50.
Is this possible?
I created the combobox just by using the forms button.
Emma

 

[Emma]

Thank you so much. I was trying to be too complicated!!