#N/A values

[Trivikram]

Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
result of a funtion or formula) values in an excel sheet?

Trivikram.

 

[FARAZ QURESHI]

Simply try:

=if(ISNA([YOUR FORMULA]),"",[YOUR FORMULA])

Insert your formula in place of [YOUR FORMULA]

 

[David Biddulph]

You can use conditional formatting to make the font white (or whatever the
background colour of the cell is).

 

[ramzi]

HI Faraz,

if have problem with ur formula... I doing like below..

=if(ISNA(=A1),"",=B1)

and

=IF(F9=0,"","=H4")

if have problem with =H4 (the formula)

thanks in advance

Simply try:

=if(ISNA([YOUR FORMULA]),"",[YOUR FORMULA])

Insert your formula in place of [YOUR FORMULA]

--

Best Regards,
FARAZ A. QURESHI

Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
result of a funtion or formula) values in an excel sheet?

Trivikram.

 

[Rick]

You can alternatively use ISERROR instead of ISNA.

Simply try:

=if(ISNA([YOUR FORMULA]),"",[YOUR FORMULA])

Insert your formula in place of [YOUR FORMULA]

--

Best Regards,
FARAZ A. QURESHI

Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
result of a funtion or formula) values in an excel sheet?

Trivikram.

 

[Gord Dibben]

Which will mask any error, not just the #N/A

Might not be desirable.


Gord Dibben MS Excel MVP

You can alternatively use ISERROR instead of ISNA.

Simply try:

=if(ISNA([YOUR FORMULA]),"",[YOUR FORMULA])

Insert your formula in place of [YOUR FORMULA]

--

Best Regards,
FARAZ A. QURESHI

Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
result of a funtion or formula) values in an excel sheet?

Trivikram.