Fresh Excel Tips

One common problem that arises in Excel is when we try to use data that has been imported in formulas, sometimes cannot interpret some of these values. To alleviate this problem, use the IF function in combination with the TYPE function to check for invalid data in the worksheet. This example will enter the text “Invalid” in column B if the value entered in column A is non-numeric, and thus, unusable in a mathematical formula.

To show invalid values in a worksheet:

1. Enter some values or text in column A.
2. Select cells B1:B10 and type the following formula: =IF(AND(TYPE(A1)=1,A1″”),A1,”Invalid”).
3. Press CTRL+Enter.

Once Excel finds a non-numeric value, it will display Invalid in the adjacent cell. You should now be set.

1. How to convert invalid numbers to valid numbers in Excel
2. How to Check for Valid Numbers Using the T Function in Excel
3. Using the OR function to check cells for text or numbers in Excel
4. How to Check Cells in Workbooks and Worksheets using Excel
5. Use the ISEVEN and ISODD functions to check if a number is even or odd