View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trea Trea is offline
external usenet poster
 
Posts: 2
Default 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)