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!

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.

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

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