#N/A

[Mayank]

How can I show an empty cell where a #N/A is displayed using function NA()?

 

[David Biddulph]

How can I show an empty cell where a #N/A is displayed using function
NA()?

If your formula returning #N/A is in A1, then try =IF(ISNA(A1),"",A1) in
another cell, or else you can replace your formula in A1 by
=IF(ISNA(your formula),"",your formula).

 

[Bob Phillips]

Use conditional formatting, with a formula of =NA() and set the font to
white.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

How can I show an empty cell where a #N/A is displayed using function

NA()?