Try

=IF(COUNTIF(A1:A100,"<7"),"yes","no")

--

HTH

Bob

"xl@lf" wrote in message
...
Is there a way to do the following without using if(OR(…, …, …, ….,
…)) for each of 100 cells? I have a column of 100 cells each
containing a number from 1 through 10. If the number 7 is greater
than any of the 100 cell’s I want it to say “yes”, otherwise “no”.

Example: if(or(7A1, 7A2, 7A3, …, 7A100), “yes”, “no”)


Thanks