Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Davies
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 11:30 PM
Looking up a value based on date and time, what's wrong? Margo Guda Excel Worksheet Functions 3 February 28th 06 03:18 PM
wts wrong with this statement Jason Excel Worksheet Functions 2 February 24th 06 03:26 PM
time sheet to calculate 2 different columns John Sullivan Excel Worksheet Functions 1 October 21st 05 06:48 AM
Time and motion chart deant Charts and Charting in Excel 0 September 21st 05 08:22 AM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"