Hi,

Since you have Excel 2010 you could wrap the whole formula in an =IFERROR() function.
i.e.

=IFERROR(original_formula,"Not NTS")

Regards