USE THE TYPE FUNCTION TO CHECK FOR INVALID VALUES USING MICROSOFT EXCEL

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.

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->.

USE THE TYPE FUNCTION TO CHECK FOR INVALID VALUES USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, TYPE function in MS Excel, IF function in Excel, AND Function in Excel, Use the TYPE function to check for invalid values using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel