Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement help please - again - got it wrong last time!
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement help please - again - got it wrong last time!
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","Ste ve"})),P3*0.7,"")) Biff "Alan Davies" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement help please - again - got it wrong last time!
=IF(AND(I3="Business",OR(Z3={"Mark","Steve","Kath" ,"Doug"})), P3*0.5,
IF(AND(I3="Person",OR(Z3={"Mark","Steve","Kath","D oug"})),P3* 0.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 - 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Looking up a value based on date and time, what's wrong? | Excel Worksheet Functions | |||
wts wrong with this statement | Excel Worksheet Functions | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel |