Check If Cell Not Empy in Multiple Rows

[muhammad susanto]

hi all..

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]data1
[/TD]
[TD]data2
[/TD]
[TD]data3
[/TD]
[TD]data4
[/TD]
[TD]target
[/TD]
[/TR]
[TR]
[TD]34
[/TD]
[TD]8745
[/TD]
[TD][/TD]
[TD]898
[/TD]
[TD]ok
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]no
[/TD]
[/TR]
[TR]
[TD]56
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]ok
[/TD]
[/TR]
</tbody>[/TABLE]

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!