Ossie, are you saying if I copy it to value it will show a real blank?,
because what I wanted to ck is instead of manual ck, I want to use formula to
ck, and i can easily move to the next anomaly by pressing button End then
down, all the blank will be passed and to next unblank cell in the same
column.

I appreciate if you have more idea.

Thanks
Frank

"OssieMac" wrote:

The cell is no longer blank after you have inserted a formula. It contains
the formula irrespective of the result of the formula.

Regards,

OssieMac

"Frank Situmorang" wrote:

Hello, I want to use the benefit of End xldown or UP on moving the cursor,
but It does not work if the cell is not really blank/no content at all. My if
statement produce " " in the cell which is not blank although it appreas
blank, So, I can not use my End xl down or up.

Can anybody help me how can I change it?, my formula is like this:
=IF(AG7=AG8,"","Ini").

Thanks in advance

Frank