Error.type 7

  • Thread starter Thread starter Malc
  • Start date Start date
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)
 
Back
Top