# IF Statement help please - again - got it wrong last time!

Discussion in 'Microsoft Excel Worksheet Functions' started by Alan Davies, May 11, 2006.

1. ### Alan DaviesGuest

i run a spreadsheet that calculates commision for sales people
Column I is a product list - 40 products or so
Column P is total sales value
Column Z is the name of a sales person who shares the commission with the
main "owner" of the worksheet. (Each worksheet is for one sales person -but
commission can be shared), there are 6 potenial sharers all of whom are in a
list called TEAM
One product"PLAN" shares the commission 50-50 between the sheet owner and
the person in Column Z, all other products share 70-30

How do i write an IF statement that says something like:
IF(I3="PLAN" and Z3="Mark or Kath or Steve etc", p3*.5, but if I3="Anything
apart from PLAN" and Z3="mark or kath or steveetc",P3*.7)

Alan Davies, May 11, 2006

2. ### BiffGuest

Hi!

Maybe something like this:

=IF(AND(I3="PLAN",OR(Z3={"Mark","Kath","Steve"})),P3*0.5,IF(AND(I3<>"PLAN",OR(Z3={"Mark","Kath","Steve"})),P3*0.7,""))

Biff

"Alan Davies" <> wrote in message
news:...
>
> i run a spreadsheet that calculates commision for sales people
> Column I is a product list - 40 products or so
> Column P is total sales value
> Column Z is the name of a sales person who shares the commission with the
> main "owner" of the worksheet. (Each worksheet is for one sales
> person -but
> commission can be shared), there are 6 potenial sharers all of whom are in
> a
> list called TEAM
> One product"PLAN" shares the commission 50-50 between the sheet owner and
> the person in Column Z, all other products share 70-30
>
> How do i write an IF statement that says something like:
> IF(I3="PLAN" and Z3="Mark or Kath or Steve etc", p3*.5, but if
> I3="Anything
> apart from PLAN" and Z3="mark or kath or steveetc",P3*.7)
>
>

Biff, May 11, 2006

3. ### Bob PhillipsGuest

IF(AND(I3="Person",OR(Z3={"Mark","Steve","Kath","Doug"})),P3* 0.7,""))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Alan Davies" <> wrote in message
news:...
>
> i run a spreadsheet that calculates commision for sales people
> Column I is a product list - 40 products or so
> Column P is total sales value
> Column Z is the name of a sales person who shares the commission with the
> main "owner" of the worksheet. (Each worksheet is for one sales

person -but
> commission can be shared), there are 6 potenial sharers all of whom are in

a
> list called TEAM
> One product"PLAN" shares the commission 50-50 between the sheet owner and
> the person in Column Z, all other products share 70-30
>
> How do i write an IF statement that says something like:
> IF(I3="PLAN" and Z3="Mark or Kath or Steve etc", p3*.5, but if

I3="Anything
> apart from PLAN" and Z3="mark or kath or steveetc",P3*.7)
>
>

Bob Phillips, May 12, 2006