A
Alan Davies
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)
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)