hide the #N/A error
 

Hi and thanks for the help. I have some calculations that show the #N/A error
because the value to correct the error will be added in the future. For now I
do not want the #N/A error visible. I know how to use conditional formatting
to make it disappear and I know how to use the =if(iserror()) method. BUT
someone showed me a formula that nested some type of NA function that took
care of the problem quite easily. I just can't remember what it is. Any
ideas? This is for version 2003. : ) THANKS

hide the #N/A error
 

=IF(ISNA(your_formula),"",your_formula)



--


Regards,


Peo Sjoblom


"SheriTingle" wrote in message
...
Hi and thanks for the help. I have some calculations that show the #N/A
error
because the value to correct the error will be added in the future. For
now I
do not want the #N/A error visible. I know how to use conditional
formatting
to make it disappear and I know how to use the =if(iserror()) method. BUT
someone showed me a formula that nested some type of NA function that took
care of the problem quite easily. I just can't remember what it is. Any
ideas? This is for version 2003. : ) THANKS

hide the #N/A error
 

if(iserror(your_formula), "", your_formula)

"Peo Sjoblom" wrote:

=IF(ISNA(your_formula),"",your_formula)



--


Regards,


Peo Sjoblom


"SheriTingle" wrote in message
...
Hi and thanks for the help. I have some calculations that show the #N/A
error
because the value to correct the error will be added in the future. For
now I
do not want the #N/A error visible. I know how to use conditional
formatting
to make it disappear and I know how to use the =if(iserror()) method. BUT
someone showed me a formula that nested some type of NA function that took
care of the problem quite easily. I just can't remember what it is. Any
ideas? This is for version 2003. : ) THANKS