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
|