+ Reply to Thread
Results 1 to 5 of 5

Formula to deal with multiple Criteria

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    2

    Formula to deal with multiple Criteria

    Hi,

    Thanks for any help I am trying to get a formula that will deduct agents & depot commissions from the total sales based on a Y for yes commission to be paid or N no commission to be paid.

    I have attached a table with an example, i did think of the if function but cant figure it out.

    Many thanks for any help
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Formula to deal with multiple Criteria

    Put the following formula in F2 and drag down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Please click the * icon below if I have helped.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Formula to deal with multiple Criteria

    Or if Cell A is empty and you do not want a zero to display, you could use:

    Please Login or Register  to view this content.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Registered User
    Join Date
    08-07-2013
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Formula to deal with multiple Criteria

    Excellent many thanks

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Formula to deal with multiple Criteria

    You are welcome.

    Glad I could help. If you are satisfied with the solution, then you may also Click on the Star to the far left, at the bottom of this Post, to Add to my Reputation.

+ 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. Excel 2007 : Index, Match, Large Formula: Multiple Criteria, Multiple Ranges
    By SimpleJack in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2013, 08:54 AM
  2. Formula Publishing Multiple Entries Originating From Multiple Criteria
    By warrior2411 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2013, 05:07 PM
  3. Replies: 1
    Last Post: 05-16-2011, 05:00 PM
  4. A macro that can deal with multiple files?
    By jlehrfeld in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-21-2006, 03:37 AM
  5. [SOLVED] how to deal with multiple matches on vlookup?
    By Ash in forum Excel General
    Replies: 3
    Last Post: 03-10-2005, 12:06 PM

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