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 |
Simplifying an If(OR(
)) statement
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 cells I want it to say yes, otherwise no. Example: if(or(7A1, 7A2, 7A3, , 7A100), yes, no) Thanks |
Simplifying an If(OR(
)) statement
Thanks Bob, thats thinking outside the box. Now Id 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) |
Simplifying an If(OR(¦)) statement
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 . |
Simplifying an If(OR(
)) statement
Just what I was looking for, another outside the box thinker. Swap "7" with "E5" and it works great, Thanks!!! |
Simplifying an If(OR(
)) statement
Try
=IF(COUNTIF(A1:A100,"<"&E5),"yes","no") -- HTH Bob "xl@lf" wrote in message ... Thanks Bob, thats thinking outside the box. Now Id 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) |
Simplifying an If(OR(¦)) statement
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!!! . |
All times are GMT +1. The time now is 07:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com