Excel and mutiple criteria

S

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
 
S

Scott

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top