Assigning a value to a text

[Eugine]

Hello,

I'm currently doing somework in Excel and would greatly appreciate some
help since I'm stuck.

I've reached this part in which you have to calculate the dscounted
price for each group of products.
The discounts are ranged as Normal (5% discount), Special (10%
discount), Exclusive (15% discount). When setting up you had to state
what category each product was without indicating the % of discount. So
I was wondering, if anyone knows how to *embed* the discount into the
text, you know masking it. So any onlooker wouldn't notice it, but I
can still calculate the discount.

Help is greatly appreciated.

 

[davesexcel]

For this example:

Select the Range A3

Goto the top menu and select Data=>Validation, in the setting tab hit
the down arrow and select list
In the source box type in these words:

Normal,Special,Exclusive

just like I have written it=> then click OK

In Range C3 enter this formula

=IF(A3="Normal",0.95,IF(A3="Special",0.9,IF(A3="Exclusive",0.85,1)))

Or

=IF(A3="Normal",0.05,IF(A3="Special",0.1,IF(A3="Exclusive",0.15,0)))

Depending on how you want to do this

Multiply you price amount to Cell C3, to either discount the price or
get the discounted amount ( depending on which formula you use)

You can place the formula anywhere, this is just an example so you can
see what happens when you use the dropdown menu