"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