+ Reply to Thread
Results 1 to 4 of 4

Need a formula that satisfies multiple OR conditions -- help!

  1. #1
    Registered User
    Join Date
    09-15-2016
    Location
    Cambridge, MA
    MS-Off Ver
    Excel 2011
    Posts
    7

    Need a formula that satisfies multiple OR conditions -- help!

    Hi Everyone,

    I'm trying to extract from 2 columns with many rows of numbers the cells that satisfy the conditions:

    100<=A1<=800 (numbers that fall between these two values)
    OR
    2000<=A1<=2400 (numbers that fall between these two values)

    But I want to evaluate two cells at the same time, so if I were to talk out the formula I want, it would go something like this:

    If (((100<=C6<=800) or (2000<=C6<=2400)) OR ((100<=F6<=800) or (2000<=F6<=2400))) put "TRUE"

    Can't figure out how to do this in Excel.

    Thank you for any help!

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Agawam, MA
    MS-Off Ver
    Microsoft Office 365
    Posts
    842

    Re: Need a formula that satisfies multiple OR conditions -- help!

    i used A1 and C1 as data for your example change where necessary...
    You were correct with the "OR" formula you just needed to add an "AND" formula to it as well.

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

  3. #3
    Registered User
    Join Date
    09-15-2016
    Location
    Cambridge, MA
    MS-Off Ver
    Excel 2011
    Posts
    7

    Re: Need a formula that satisfies multiple OR conditions -- help!

    Thank you so much dosydos!
    That worked!
    Do the commas before each AND mean OR?
    Thank you again!

  4. #4
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Agawam, MA
    MS-Off Ver
    Microsoft Office 365
    Posts
    842

    Re: Need a formula that satisfies multiple OR conditions -- help!

    You're welcome, and yes its reads just like your written out example witht he commas designating all the different Or's

    thanks for the Rep

+ 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] Pull Information From Multiple Columns That Satisfies Multiple Criteria
    By slindfors in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-01-2015, 04:39 PM
  2. If condition satisfies with multiple conditions
    By excel_hunt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2014, 02:09 PM
  3. Creating a formula in a table that satisfies multiple assumptions
    By Baris Onay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2014, 01:12 PM
  4. [SOLVED] formula that satisfies two conditions and search the name
    By jpgmaas in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-22-2013, 06:09 AM
  5. [SOLVED] formula that satisfies two conditions and search the name on the other tab.
    By jpgmaas in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-29-2013, 03:54 AM
  6. Finding if price data between cells satisfies conditions
    By northerng in forum Excel General
    Replies: 6
    Last Post: 06-02-2011, 09:58 PM
  7. Formula to select value that satisfies conditions
    By bmind in forum Excel General
    Replies: 10
    Last Post: 04-03-2009, 11:07 AM

Tags for this Thread

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