I often use if statements to return empty cells, for example:

=IF(a1=0,"ERROR","")

The trailing "" returns an empty cell. The problem is, it is not TRULY
empty. If I fill that formula down, I cannot, for example, jump from
one "ERROR" cell to the next by hitting Ctrl arrow-down because it
seems to think that these empty cells have contents.

Is there a way to designate, in such a formula as above, to return a
TRULY empty cell?

Thanks


--
cwinters
------------------------------------------------------------------------
cwinters's Profile: http://www.excelforum.com/member.php...o&userid=18386
View this thread: http://www.excelforum.com/showthread...hreadid=393270