PDA

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



choubix
06-21-2008, 02:43 AM
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
06-21-2008, 02:45 AM
=IF(COUNTIF(A:A,0),0,1)

mikerickson
06-21-2008, 08:07 AM
=SIGN(PRODUCT(A:A))

choubix
06-21-2008, 11:12 AM
thanks!