+ Reply to Thread
Results 1 to 2 of 2

Using multiple criteria in an IF statement

  1. #1
    Registered User
    Join Date
    12-31-2011
    Location
    Joice, Iowa
    MS-Off Ver
    Excel 2007
    Posts
    5

    Using multiple criteria in an IF statement

    I am trying to create a formula so if cell A43 equals 9 and cell X19 has data it runs the IF statement, other wise leave the cell blank. But if cell A43 equals 10 and both of cells X19 and X31 have data it runs the if statement, other wise leave the cell blank. This is the string I created but it always leaves the cell blank. Any help is appreciated:
    =IF(AND(OR(Scores!A43=9),(ISBLANK(Scores!X19))),"",IF(BY44=Scores!A31,0,BV44)),IF(AND(OR(Scores!A43=10),ISBLANK(ScoresX31),(ISBLANK(Scores!X19))),"",IF(BY44=Scores!A31,0,BV44))

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Using multiple criteria in an IF statement

    Here's my best guess...

    =IF(OR(AND(Scores!A43=9,Scores!X19<>""),AND(Scores!A43=10,Scores!X31<>"",Scores!X19<>"")),IF(BY44=Scores!A31,0,BV44),"")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  2. [SOLVED] If statement that will look among multiple criteria and generate a statement
    By liz5818 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2013, 04:12 PM
  3. [SOLVED] Multiple Criteria for an IF Statement
    By Markvx in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 01:05 PM
  4. [SOLVED] If Statement with Multiple Criteria
    By clangley in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 11-06-2012, 12:04 PM
  5. Multiple criteria if statement
    By marlin5124 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-11-2011, 03:18 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