Try something like the following to test the value of A1. It will return one
of three results:
"#VALUE In A1" if A1 has a #VALUE error
"Other Error In A1" if A1 has some other error (e.g., #DIV/0!)
"No Error In A1" if there is no error in A1.
=IF(ISERROR(A1),IF(ERROR.TYPE(A1)=3,"#VALUE In A1","Other Error In A1"),"No
Error In A1")
If you don't want to consider #N/A as an error (it may or may not be a real
error, depending your context) change ISERROR(A1) to ISERR(A1).
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
