all cells in range > 0

  • Thread starter Thread starter Mire
  • Start date Start date
M

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
 
Just as an alternative
=IF(COUNTIF(A1:A100,">0")>1,"OK","No")

--

HTH

Bob Phillips

steve said:
Mire;

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

--
sb
Mire said:
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
Click to expand...
Click to expand...
 
Back
Top