hide the #N/A error

[Guest]

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

 

[Peo Sjoblom]

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



--


Regards,


Peo Sjoblom

 

[Guest]

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

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



--


Regards,


Peo Sjoblom