SUMPRODUCT help

[willroy]

I am trying to use SUMPRODUCT to calculate either 10% or 15% of
specific cell dependent if there is an "S" or an "A" in a differen
cell.

At the moment its working like this:

If there is a "S" in cell X the answer will be 15% of cell Z

But I want it to work like this:

If there is an "S" in cell X the answer will be 15% of cell Z OR
If there is an "A" in cell X the answer will be 10% of cell Z

I need both formula's to give an answer in the same cell.

Maybe SUMPRODUCT is not the formula im looking for?

Please help.

Wil

 

[Bob Umlas]

=SUMPRODUCT((X="S")*(Z*.15)+(X="A")*(Z*.1))

Bob Umlas
Excel MVP

 

[Arvi Laanemets]

Hi

Maybe something like
=((X1="A")*0.1+(X1="S")*0.15)*Z1

 

[Frank Kabel]

Hi
one way:
=IF(X1="S",Z1*0.15,IF(X1="A",Z1*0.1,"")

HTH
Frank

 

[Bob Phillips]

You have all read it as X holding either A or S. I read it as containing,
and got in a right pickle with a SUMPRODUCT OR formula with erroir
handling<vbg>

Bob

 

[Frank Kabel]

Hi Bob
and only the OP will know
Frank

 

[Arvi Laanemets]

You have all read it as X holding either A or S. I read it as containing,
and got in a right pickle with a SUMPRODUCT OR formula with erroir
handling<vbg>

It was easier so ))

Arvi Laanemets

 

[Bob Phillips]

Indeed it was. My solution (or lack of it) is still in tatters on the
floor.

Bob

 

[Frank Kabel]

Indeed it was. My solution (or lack of it) is still in tatters on the
floor.

Bob

and it's rotfl, isn't it <vbg>
Frank

 

[Bob Phillips]

It is certainly smirking! I'll get the b*%$*d, out come the matches.