Thread: all cells in range 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mire Mire is offline
external usenet poster
  
Posts: 8
Default all cells in range 0
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


Reply With QuoteReply With Quote