+ Reply to Thread
Results 1 to 9 of 9

if with 3 criteria

  1. #1
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    if with 3 criteria

    Hello,

    Thanks for reading my post. I would like to have some help on an if statements with 3 criteria.

    I have attached a worksheet here. Commission rate is 10% with 3 exceptions:

    1) If column A match any value in column K, zero commission
    2) If column b > column c, zero commission
    3) if in Column A the number is ANDR05, and column B is less than column C, then 5% commission, If column c is greater than column B, zero commission

    Thanks for the help.

    Jackson
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: if with 3 criteria

    Try

    F3
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then format the cell as percentage
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: if with 3 criteria

    Hi,


    a possible approach

    Please Login or Register  to view this content.
    Regards
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,734

    Re: if with 3 criteria

    EDIT
    all answered before me - ignore
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: if with 3 criteria

    Dear Ankur,
    If add *100 after your formula then values comes 0%, 5%, 10%
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  6. #6
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: if with 3 criteria

    Quote Originally Posted by avk View Post
    Dear Ankur,
    If add *100 after your formula then values comes 0%, 5%, 10%
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Need Percentage so it would be better if we format them into percentage instead number for better calculation.

  7. #7
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: if with 3 criteria

    Ya Ankur, thats correct, my intension is without formatting do directly 5% or 10%.

  8. #8
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: if with 3 criteria

    Quote Originally Posted by avk View Post
    Ya Ankur, thats correct, my intension is without formatting do directly 5% or 10%.
    yes then it is ok and you will always need to remember these numbers are not actual number but percentage.

  9. #9
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    Re: if with 3 criteria

    shukla.ankur281190, avk, etaf and canapone,

    Thank you very much for all your helps. I very much appreciated for all the replies.

    Jackson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-03-2017, 08:40 AM
  2. Replies: 4
    Last Post: 11-01-2016, 03:28 PM
  3. VBA Macro Dividing Values Based upon Matching Criteria and Description Criteria
    By pvsvprasad in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-18-2016, 12:39 PM
  4. [SOLVED] Count of rows in an array that meet criteria in column 2 and different criteria in column3
    By reynoldslarry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 01:51 AM
  5. Replies: 1
    Last Post: 09-03-2013, 07:41 PM
  6. Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  7. MACROS: Sort by multiple criteria - Create tabs based off of criteria
    By svineyard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 10:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1