14. Use the TYPE function to check for invalid values
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
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
No comments:
Post a Comment