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

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

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

You can use conditional formatting to hide the errors on the sheet or,
depending on what version of Excel you're using, you can set it so that
errors don't print (on paper).

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"Fred Holmes" wrote in message
...
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

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

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.

"Fred Holmes" wrote:

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

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

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.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Fred Holmes" wrote:

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