SUMPRODUCT help

  • Thread starter Thread starter willroy
  • Start date Start date
W

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
 
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
 
Bob Phillips said:
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>
Click to expand...

It was easier so :-)))

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

Bob
 
Back
Top