+ Reply to Thread
Results 1 to 5 of 5

IF Formula for Multiple criteria

  1. #1
    Registered User
    Join Date
    09-28-2020
    Location
    NYC
    MS-Off Ver
    365
    Posts
    11

    IF Formula for Multiple criteria

    Hi,

    I need help with an IF formula which is based on two different criteria. Please see attached example:

    Any suggestions are appreciated.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: IF Formula for Multiple criteria

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: IF Formula for Multiple criteria

    In C6, try this:
    =IFS(A6="Red","OK",A6="Blue",IF(AND(B6>0,B7>0),"Yes","No"))

    Then copy this to C11 and C14

  4. #4
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,278

    Re: IF Formula for Multiple criteria

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

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: IF Formula for Multiple criteria

    Sorry, didn't read the requirements properly so my formula only returns Yes or No, not OK for Red.

    Note that, in your sample file, Red in A6 has a trailing space which will affect the results.

    This is another alternative:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. [SOLVED] Retrieving multiple text strings based on multiple criteria (formula update)
    By McKneezy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2019, 08:52 PM
  2. Multiple criteria formula with date as criteria
    By Phlegon_of_Tralles in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-06-2019, 09:27 PM
  3. [SOLVED] Formula to count matches between multiple columns on different sheets w/ multiple criteria
    By RICK JAMES in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-05-2019, 03:28 PM
  4. Replies: 4
    Last Post: 04-14-2017, 05:14 PM
  5. [SOLVED] Need Excel formula to use INDEX and MATCH with multiple criteria's over multiple ranges.?
    By mchilapur in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-22-2017, 08:56 AM
  6. Formula for summing on multiple row criteria and a dynamic column criteria
    By ianswilson815 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2016, 01:58 PM
  7. Replies: 1
    Last Post: 05-16-2011, 05:00 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