Use the TYPE function to check for invalid values - Logical Functions - Microsoft Excel Tutorials

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

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

Watch the Video Tutorial - https://www.youtube.com/watch?v=0aN7FEbYJq4

  Hope You Like This Tutorial - Give Comments