Nope.

If you don't need the formula, you could use this:

=if(a1=0,"Error","deletethis")
Drag down the column
convert to values (edit|copy, edit|paste special|Values)

Then edit|replace
what: deletethis
with: (leave blank)
replace all.



cwinters wrote:

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

--

Dave Peterson