Format a cell such that "#NAME?" reads/appears "N/A"?

[Fred Holmes]

Is there a custom number format for a cell such that if the error
"#NAME?" is produced by the formula in the cell, the cell will "read"
"N/A" (Not Available)? Which really means the referenced name does
not appear in the dataset and is presumed/calculated to be zero.

If I print out the "report", having some cells show "#NAME?" would
just be confusing to a reader of the report who is not familiar with
coding Exeel.

Thanks,

Fred Holmes

 

[JLatham]

Are you referring to the #N/A! error or the #NAME? error?? The #NAME? error
is normally the result of misspelling a function (as SMU instead of SUM) or
of referring to a function that is not available, such as one from the
Analysis ToolPak without having that add-in active. See Excel help on #NAME?
for more possibilities.

If you're speaking of the #N/A! error, that is a different deal, and can be
handled with =IF(ISNA(yourfunction),"",yourfunction) type formula.

 

[Shane Devenshire]

Hi,

If all you want to do is avoid printing out errors:
2002 or 2003: Choose File, Page Setup, Sheet tab, open the drop down beside
Cell errors as and choose <blank>
2007: Page Layout, click the Page Setup quick launch button at the bottom
right corner of the Page Setup group and choose same steps as above.

This feature is not available in 2000 or earlier.