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

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

Thanks Bob, that’s thinking outside the box. Now I’d like to swap out
the 7 with a cell reference. Such that
=IF(COUNTIF(A1:A100,"<E5"),"yes","no") but that's not working.

Example: if(or(E5A1, E5A2, E5A3, …, E5A100), “yes”, “no”)

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
.

Just what I was looking for, another outside the box thinker. Swap
"7" with "E5" and it works great, Thanks!!!

Try

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

--

HTH

Bob

"xl@lf" wrote in message
...
Thanks Bob, that’s thinking outside the box. Now I’d like to swap out
the 7 with a cell reference. Such that
=IF(COUNTIF(A1:A100,"<E5"),"yes","no") but that's not working.

Example: if(or(E5A1, E5A2, E5A3, …, E5A100), “yes”, “no”)

No problem. Can you click my post as being helpful.

Zoltan

"xl@lf" wrote:


Just what I was looking for, another outside the box thinker. Swap
"7" with "E5" and it works great, Thanks!!!

.