#N/A
 

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

#N/A
 

"Mayank" wrote in message
...
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).
--
David Biddulph

#N/A
 

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)

"Mayank" wrote in message
...
How can I show an empty cell where a #N/A is displayed using function
NA()?