Error.type 7

M

Malc

This example does not work in Excel 8.0a.
The "if" function when cell E50 is not an error should
give you the value in e50, however it does not. The text
is from Excel help.

Example

The following formula checks cell E50 to see whether it
contains a #N/A error value. If it does, the text "Value
is not available" is displayed. Otherwise, the value in
E50 is returned.

IF(ERROR.TYPE(E50)=7, "Value is not available", E50)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Still having problems with If --Elseif 13
Check for error.type in same cell 2
using error type and if statement to return a value. 6
Error.Type or IsError to trap #VALUE! and #NUM! 1
Look up if a value from an array "A" is in either array "B" or "C" 8
Vlookup & ErrorType 2
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET 6
Use TODAY() function as the criteria in a SUMIF formula 1

Top