View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Holmes Fred Holmes is offline
external usenet poster
 
Posts: 112
Default 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