I have an instance where #N/A appears and I cannot seem to figure out how to hide it. I have been using this formula:
=IF(ERROR.TYPE(K6),"error","no error")
or
=IF(ERROR.TYPE(K6)=7,"error","no error")
If K6=#N/A the result is "error"
but if K6 != #N/A it should print "no error", but the result is #N/A
Why is this? How can I make "no error" print?
Bookmarks