LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Davies
 
Posts: n/a
Default IF Statement help please

i run a spreadsheet that calculates commision for sales people

Column I is a product list
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)

some products share the commission 50-50 between the sheet owner and the
person in Column Z
other products share 70-30

how do i write an IF statement that says something like:
IF(I3="Business" and Z3="Mark", p3*.5, but if I3="Person" and Z3="mark"
P3*.7)

I hope the question is clear!!

TIA


 
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
Returning Specific Cell Content using IF Statement weeclaire Excel Discussion (Misc queries) 0 February 17th 06 09:25 AM
SET statement tutorial Daminc Excel Discussion (Misc queries) 13 January 17th 06 04:47 PM
Long IF Statement rmitchell87 Excel Discussion (Misc queries) 2 October 2nd 05 03:50 AM
If statement Matt Montagliano Excel Discussion (Misc queries) 1 September 8th 05 08:47 PM
Do I need a sumif or sum of a vlookup formula? PeterB Excel Worksheet Functions 0 June 1st 05 12:23 PM


All times are GMT +1. The time now is 12:17 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"