IF and OR Functions
 

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)

IF and OR Functions
 

=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" wrote in message
...
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)

IF and OR Functions
 

Thank you Bob - You are the Best!!

"Bob Phillips" wrote:

=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" wrote in message
...
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)