Try this formula in AA1:

=1*COUNTA(A1:Z1)0

or alternatively:

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

and copy down the columns for as many rows as you need to look at.

Hope this helps.

Pete

On Sep 25, 10:28 pm, Jase4now
wrote:
I need to write an IF statement that will look at all the cells in a row, and
if it finds anything, letters or numbers, it then places a "1" in the AA
column of that row.

Thanks