Check If Cell Not Empy in Multiple Rows

[muhammad susanto]

hi all..

how to check if cell not empty, say ok otherwise no

data1	data2	data3	data4	target
34	8745		898	ok
				no
56				ok

<tbody>
</tbody>

any help, thanks in advance.

.sst

 

[JoeMo]

Assuming the header data1 is in A1, then in E2 and copy down:

=IF(COUNTA(A2:D2)>0,"ok","no")

Also assumes "empty" cells are truly empty and not containing a formula that returns "" (null string).

 

[muhammad susanto]

Hi Joe..thank you worked it for me!