How do I create a formula that searchs 1-cell for a range of numbe

[Guest]

I'm looking to search 1-cell for a range of numbers i.e
I want to enter a formula in cell C-1
if cell A-1 is >16 or <30, I want the formula to provide me the info in
cell B-1. If the criteria is not met, I want to see a null value.

Let me know. Thanks!

 

[Bob Phillips]

=IF(AND(A1>16,A1<30),A1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks Bob. I was missing the second A1 entry for the <30! This eleviated
my 2 hours of torture trying to figure this out.

 

[Bob Phillips]

Glad to be of service.

Bob

Thanks Bob. I was missing the second A1 entry for the <30! This eleviated
my 2 hours of torture trying to figure this out.