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

G

Greg-B

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!
 
B

Bob Phillips

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

--

HTH

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

Greg Bobak

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

Bob Phillips

Glad to be of service.

Bob

Greg Bobak said:
Thanks Bob. I was missing the second A1 entry for the <30! This eleviated
my 2 hours of torture trying to figure this out.
Click to expand...
 
Top