Prev: Auto Populate a Template
Next: Code not working
From: xl on 16 Mar 2010 13:05
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(7>A1, 7>A2, 7>A3, …, 7>A100), “yes”, “no”)


Thanks
From: xl on 16 Mar 2010 13:55
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(E5>A1, E5>A2, E5>A3, …, E5>A100), “yes”, “no”)
From: Zoltan on 16 Mar 2010 14:01
if(7>max(A1:A100),"yes","no") should do it

"xl(a)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 cell's I want it to say “yes”, otherwise “no”..
>
> Example: if(or(7>A1, 7>A2, 7>A3, …, 7>A100), “yes”, “no”)
>
>
> Thanks
> .
>
From: xl on 16 Mar 2010 14:12

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

From: Zoltan on 17 Mar 2010 09:05
No problem. Can you click my post as being helpful.

Zoltan

"xl(a)lf" wrote:

>
> Just what I was looking for, another outside the box thinker. Swap
> "7" with "E5" and it works great, Thanks!!!
>
> .
>
 | 
Pages: 1
Prev: Auto Populate a Template
Next: Code not working