How do I test whether returned value is a number?

 

Use the Excel function =ISNUMBER() which will fail on any #N/A.

 

Example:

 

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017