Either function?

[Legacy 180354]

Hi
I was wondering, is there an Either function (or something like that) in excel?
what I'm trying to do is as follows:
below is my data starting in A1
<table border="0" cellpadding="0" cellspacing="0" width="164"><colgroup><col style="mso-width-source:userset;mso-width-alt:5997;width:123pt" width="164"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:123pt" align="right" height="20" width="164">1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" align="right" height="20">2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" align="right" height="20">11</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" align="right" height="20">10</td> </tr> </tbody></table>In A5 I want to make the formula, if either of these numbers are greater then 5, it should return True, if not False. I tried doing =if(or(a1>5,a2>5,a3>5,a4>5),true,false). This works fine, however when I have a list of a lot of numbers, it's quite difficult to do every cell separately. Is there a a way I can do =if(either(a1:a4>5),true,false) or something similar?

Thank you!

 

[Jonmo1]

Try

=MAX(A1:A100)>5


Hope that helps.

 

[VoG]

Try

=MAX(A1:A4)>5

 

[T. Valko]

Hi
I was wondering, is there an Either function (or something like that) in excel?
what I'm trying to do is as follows:
below is my data starting in A1
<TABLE cellSpacing=0 cellPadding=0 width=164 border=0><COLGROUP><COL style="WIDTH: 123pt; mso-width-source: userset; mso-width-alt: 5997" width=164></COLGROUP><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="WIDTH: 123pt; HEIGHT: 15pt" align=right width=164 height=20>1</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" align=right height=20>2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" align=right height=20>11</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="HEIGHT: 15pt" align=right height=20>10</TD></TR></TBODY></TABLE>In A5 I want to make the formula, if either of these numbers are greater then 5, it should return True, if not False. I tried doing =if(or(a1>5,a2>5,a3>5,a4>5),true,false). This works fine, however when I have a list of a lot of numbers, it's quite difficult to do every cell separately. Is there a a way I can do =if(either(a1:a4>5),true,false) or something similar?

Thank you!

One way...

=COUNTIF(A1:A4,">5")>0