data in cells

[Ron]

I want to look through a range of cells (A1:z1) and if any one of the cells
is not blank I would like to return a 1.

Thanks
Ron

 

[zackb]

Hi,

How about ...

=IF(COUNTBLANK(A1:Z1),1,0)

 

[Ron]

Your formula returns a value if any one cell is blank, I need it to return a
vlaue is any on cell is not blank.

 

[zackb]

Oh, my apologies. Maybe you can try this then ...

=IF(COUNTA(A1:Z1),1,0)