View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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