Convert "" to real blank cell
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
|