all cells in range > 0

[Mire]

Hi,
In sheet how can I check if one (or more) of 100 cells in range A1:A100 is >
0 ?

Ex.
Formula in B2 = if [at least one of cells in range (a1:a100) is] > 0 , "ok"
, "no"

Thanks in advance

 

[steve]

Mire;

=If(Min(A1:A100)>0,"OK","No")

 

[Bob Phillips]

Just as an alternative
=IF(COUNTIF(A1:A100,">0")>1,"OK","No")

--

HTH

Bob Phillips

Mire;

=If(Min(A1:A100)>0,"OK","No")

--
sb

Hi,
In sheet how can I check if one (or more) of 100 cells in range A1:A100 is

0 ?

Ex.
Formula in B2 = if [at least one of cells in range (a1:a100) is] > 0 , "ok"
, "no"

Thanks in advance