Working out percentages in combo boxes

  • Thread starter Thread starter Emma
  • Start date Start date
E

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
 
Hi Emma!

In the example below, I have the Cost in cell A2 and the results in B2.
The combobox have the "Cell link" to D5 and "Inputrange" in I5:I10 (The
values 0%, 50%, 55%, 60% and 65%), instead of "No discount" I use 0.
In the cell B2 I enter the following formula:
=SUM(A2-(A2*INDEX(I5:I10;D5)))

If you need to have the text "No discount", instead of 0, then the formula
in B2 looks like this:
=IF(D5=1;A2;SUM(A2-(A2*INDEX(I5:I10;D5))))


Stefan Hägglund
Microsoft


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
 
Back
Top