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

1. ## 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!  Register To Reply

2. ## 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:  `Please Login or Register  to view this content.`  Register To Reply

3. ## 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!  Register To Reply

4. ## 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   Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 