if(7max(A1:A100),"yes","no") should do it

"xl@lf" wrote:

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 cells I want it to say €œyes€�, otherwise €œno€�..

Example: if(or(7A1, 7A2, 7A3, €¦, 7A100), €œyes€�, €œno€�)


Thanks
.