# 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)

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)
>
>

Bob Phillips
Guest
Posts: n/a

 12th May 2006
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)
>
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?S2F0aHk=?= Microsoft Outlook Discussion 7 9th Apr 2007 02:54 AM anthony.carter@westyorksfire.gov.uk Microsoft Access Reports 2 12th Mar 2007 12:43 PM =?Utf-8?B?UmFuZHk=?= Microsoft Access Macros 2 17th May 2004 07:16 PM Ryan Windows XP Internet Explorer 0 3rd May 2004 05:04 PM -\$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM

Features