Simplifying an If(OR(
)) statement
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
|