Excel and mutiple criteria

[Scott]

this is my first time on this site so please bare with me.
I have an Excel spreadsheet with a column that has different categories,
i.e. A,B,C,D and E. Each one of the categories has a discount attached to it.
A is .50 as an example
B is .60
C is .70
D is .80
E is .90
The categories are in column B and the value they are discounted from are in
column F.
So what I need is a formula that states if column B has an A value mulitply
it by .50, but if it has a B mulitply by .60 and so on. I have inserted a
column G to represent the finished value

 

[Don Guillett]

Look in the help index for
LOOKUP

 

[Scott]

I read the helpl section prior to posting this and was leading down the
"sumproduct" route, not so?

 

[Scott]

I read lookup but could not figure how it applied to my challenge

 

[Pete_UK]

If those are your only categories, then you can put this in G2:

=F2*((CODE(UPPER(B2))-64)*0.1+0.4)

and copy down as appropriate.

Hope this helps.

Pete