PC Review


Reply
Thread Tools Rate Thread

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

 
 
Alan Davies
Guest
Posts: n/a
 
      11th May 2006

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 With Quote
 
 
 
 
Biff
Guest
Posts: n/a
 
      11th May 2006
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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 With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a
 
      12th May 2006
=IF(AND(I3="Business",OR(Z3={"Mark","Steve","Kath","Doug"})), P3*0.5,
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Enter Network Password" again & again & again & again..... =?Utf-8?B?S2F0aHk=?= Microsoft Outlook Discussion 7 9th Apr 2007 02:54 AM
I think I got it wrong again....... anthony.carter@westyorksfire.gov.uk Microsoft Access Reports 2 12th Mar 2007 12:43 PM
Help! Anyone! Please Please Please Please Please Please =?Utf-8?B?UmFuZHk=?= Microsoft Access Macros 2 17th May 2004 07:16 PM
I got it i got it i got ride of the stupid about:blank web page and the aifind! Ryan Windows XP Internet Explorer 0 3rd May 2004 05:04 PM
Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! -$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:53 PM.