Microsoft Excel Functions & Formulas

Use the TYPE function to check for

invalid values

Sometimes Excel cannot interpret some values, especially

imported data. As an example, let’s say a cell contains an apparent

value but the calculation leads to an incorrect result. To prevent

this, use the IF function in combination with TYPE to check for

invalid data in the worksheet. This example will enter the text

“invalid value” in column B if the value entered in column A is not

numeric.

4

To show invalid values in a worksheet:

1. Enter some values or text in column A.

2. Select cells B2:B10 and type the following formula:

=IF(AND(TYPE(A2)=1,A2""),A2,"invalid value").

3. Press <Ctrl+Enter>.

Logical Functions ...