IF and OR Functions

[Trea]

Please tell me what's wrong with this formula?

=IF(OR(A1:A88=14,41,38,20,46,18,22,24,12,11,59,48),"YES","NO")

I'm trying to create a function that will look for numbers "14, 41, 38,
20,46, 18, 22, 24, 12, 11, 59, or 48" within the column range A1:A88. If
these numbers appear in the column range, then "Yes", otherwise "No."

Thank you for your help. (P.S. Using Excel version 2003)

 

[Bob Phillips]

=IF(SUM(COUNTIF(A1:A88,{14,41,38,20,46,18,22,24,12,11,59,48}))>0,"YES","NO")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Trea]

Thank you Bob - You are the Best!!

=IF(SUM(COUNTIF(A1:A88,{14,41,38,20,46,18,22,24,12,11,59,48}))>0,"YES","NO")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)