I actually am not using Excel 2010, but 2003. I tried wrapping the whole formula in "ISNA" instead of "IFERROR" and I get "True" or "False" instead of "Not NTS" or "Category 1" or "Category 2." How can Excel 2003 to just tell me what I originally asked for i.e. "Cat 1", "Cat 2", or "Not NTS", instead of "True" or "False"?
Hi,
It's a bit messy but you need to wrap the formula as follows
=IF(ISERROR(original_formula),"Not NTS",original_formula)
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks