Excel and mutiple criteria
 

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

Excel and mutiple criteria
 

Look in the help index for
LOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Scott" wrote in message
...
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

Excel and mutiple criteria
 

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

"Don Guillett" wrote:

Look in the help index for
LOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Scott" wrote in message
...
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

Excel and mutiple criteria
 

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

"Scott" wrote:

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

"Don Guillett" wrote:

Look in the help index for
LOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Scott" wrote in message
...
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

Excel and mutiple criteria
 

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

On Jan 20, 7:20*pm, Scott wrote:
I read lookup but could not figure how it applied to my challenge



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

"Don Guillett" wrote:

Look in the help index for
LOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Scott" wrote in message
...
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- Hide quoted text -

- Show quoted text -