Replacing an Error
 

How do you replace an error (in my case, #N/A) with a space? The cell shows
that error until I type information into the cell next to it that gives it
information. I would like for the cell to remain blank until it needs to be
used. Is there a formula for this? I know I can keep it from showing when I
print, but I need to send this as an e-mail and do not want the error to
show. Thanks!

Replacing an Error
 

Excel 2003 HELP
#N/A

=IF(ISERROR(old_formula),"",old_formula)

"A" wrote:

How do you replace an error (in my case, #N/A) with a space? The cell shows
that error until I type information into the cell next to it that gives it
information. I would like for the cell to remain blank until it needs to be
used. Is there a formula for this? I know I can keep it from showing when I
print, but I need to send this as an e-mail and do not want the error to
show. Thanks!

Replacing an Error
 

But, where do I place this formula?

"Vacation's Over" wrote:

Excel 2003 HELP
#N/A

=IF(ISERROR(old_formula),"",old_formula)

"A" wrote:

How do you replace an error (in my case, #N/A) with a space? The cell shows
that error until I type information into the cell next to it that gives it
information. I would like for the cell to remain blank until it needs to be
used. Is there a formula for this? I know I can keep it from showing when I
print, but I need to send this as an e-mail and do not want the error to
show. Thanks!

Replacing an Error
 

in the cell in which you don't need the #N/A to appear.

"A" wrote:

But, where do I place this formula?

"Vacation's Over" wrote:

Excel 2003 HELP
#N/A

=IF(ISERROR(old_formula),"",old_formula)

"A" wrote:

How do you replace an error (in my case, #N/A) with a space? The cell shows
that error until I type information into the cell next to it that gives it
information. I would like for the cell to remain blank until it needs to be
used. Is there a formula for this? I know I can keep it from showing when I
print, but I need to send this as an e-mail and do not want the error to
show. Thanks!