Mire;

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

--
sb
"Mire" wrote in message
...
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