i run a spreadsheet that calculates commision for sales people

Column I is a product list
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)

some products share the commission 50-50 between the sheet owner and the
person in Column Z
other products share 70-30

how do i write an IF statement that says something like:
IF(I3="Business" and Z3="Mark", p3*.5, but if I3="Person" and Z3="mark"
P3*.7)

I hope the question is clear!!

TIA

=IF(AND(I3="Business",Z3="Mark"), P3*.5,
IF(AND(I3="Person",Z3="mark"),P3*.7,""))


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Alan Davies" wrote in message
...
i run a spreadsheet that calculates commision for sales people

Column I is a product list
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)

some products share the commission 50-50 between the sheet owner and the
person in Column Z
other products share 70-30

how do i write an IF statement that says something like:
IF(I3="Business" and Z3="Mark", p3*.5, but if I3="Person" and Z3="mark"
P3*.7)

I hope the question is clear!!

TIA