Solved: any value in a range = 0 then return 0 ?

[choubix]

hello,

is it possible to have a IF on a range??
I'd need a cell to return 0 if any value in a column = 0, 1 otherwise.
there are blank cells between the values in the column


thanks!

[Bob Phillips]

=IF(COUNTIF(A:A,0),0,1)

[mikerickson]

=SIGN(PRODUCT(A:A))

[choubix]

thanks!