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