+ Reply to Thread
Results 1 to 4 of 4

Change from checking if 2 conditions are true to if any of 4 conditions are true

  1. #1
    Registered User
    Join Date
    03-21-2014
    Location
    utah, usa
    MS-Off Ver
    Excel 2007
    Posts
    6

    Change from checking if 2 conditions are true to if any of 4 conditions are true

    I have 3 columns. The worksheet checks if column C is >130 AND if one of the 2 conditions are met... if column A is > than 370 OR column B is >250.

    In other words column C has to be true first, then it checks if column A OR B are true. If so, it returns "show", if not, it returns "hide"

    I was using IF(and(or(A>370,B>250),C>130),"show","hide")

    Question: How can I change this to check If column A>370 OR column B>250 OR column C>130 OR column D>130.

    In other words any of the 4 conditions met will return the word "show", otherwise return "hide"?

  2. #2
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: Change from checking if 2 conditions are true to if any of 4 conditions are true

    =IF(OR(A:A>370,B:B>250,C:C>130,D:D>130),"show","hide")
    Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.

    Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
    If you're happy with an answer given, please click the * under the person's name to boost their reputation.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Change from checking if 2 conditions are true to if any of 4 conditions are true

    Try this:

    =IF(OR(A1>370,B1>250,C1>130,D1>130),"show","hide")

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    01-06-2014
    Location
    Columbus, IN
    MS-Off Ver
    2013/O365
    Posts
    41

    Re: Change from checking if 2 conditions are true to if any of 4 conditions are true

    add each of the additional OR criteria with a comma. the OR() function isn't limited to 2 criteria
    IF(or(A>370,B>250,C>130,D>130),"show","hide")

    Beat me to it while I was typing
    Last edited by russc2541; 03-26-2014 at 02:23 PM.
    -Russell

+ 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: 1
    Last Post: 03-26-2014, 02:14 PM
  2. Count if 2 conditions are true
    By Thrava in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  3. Count if 2 conditions are true
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  4. Count if 2 conditions are true
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  5. Count if 2 conditions are true
    By Thrava in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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