| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A
How can I show an empty cell where a #N/A is displayed using function NA()?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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()? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
