The ISNUMBER function is very useful to find out if a cell value is a number. This function can also be combined with IF and Then statements in Excel for various purposes. In this article, we will show three practical examples of how to use the ISNUMBER function with IF and Then statements in Excel.
How to Use ISNUMBER Function with IF and Then Statements in Excel: 3 Practical Examples
In this article, we will demonstrate three practical examples of how to use the ISNUMBER function with IF and Then statements in Excel. We will use the following dataset for this purpose.
Example 1: Investigate If a Cell Starts with Number
In the first example, we will investigate if a cell starts with a number or not. We will follow these steps to do so.
Steps:
- First of all, select cell C5 and write down the following formula.
=IF(ISNUMBER(VALUE(LEFT(B5,1))),"True","False")
- Hence, press Enter.
- As a result, you will be able to get the return of the functions, and the return is False.
- LEFT(B5,1) returns the first character from cell B5.
- ISNUMBER(VALUE(LEFT(B5,1)) checks if the first character of cell B5 is a number or not.
- IF(ISNUMBER(VALUE(LEFT(B5,1))),”True”,”False”) returns True if the first character is a number and False if the first character is not a number.
- Then AutoFill this formula to the rest of the cells in column C.
- As a result, you will have outputs for all the other cells.
Read More: How to Use COUNTIF & ISNUMBER to Count Numbers in Excel
Example 2: Check If a Cell Value is a Number
In this example, we will check a cell value to see if it’s a number. The process for doing so is described below.
Steps:
- First, click on cell C5 and type the following formula, and press Enter.
=IF(ISNUMBER(B5),"Yes","No")
- ISNUMBER(B5) checks if the value of cell B5 is a number or not.
- IF(ISNUMBER(B5),”Yes”,”No”) returns Yes if cell B5 contains a number and returns No if the value of cell B5 is not a number.
- Finally, AutoFill this formula to the rest of the cell to get the outputs for all passwords.
Read More: Excel ISNUMBER Not Working
Example 3: Look for a Text in a Cell
In the last example, we will look for a specific text in a cell. Follow these steps to learn how to do it.
Steps:
- First, select cell C5 and write down the formula given below.
=IF(ISNUMBER(SEARCH("john", B5)), "Yes", "No")
- After that, hit Enter to get your desired output.
- SEARCH(“john”, B5) finds the text “john” and returns its position.
- IF(ISNUMBER(SEARCH(“john”, B5)), “Yes”, “No”) returns Yes if the SEARCH function returns a number. Otherwise, it returns No.
- Then AutoFill this formula to the rest of the cells in column C.
- Hence, you will get the outputs for all the passwords in column B.
- Don’t forget to give proper cell references or you won’t get the desired results.
- If you want to find out if a cell ends with a number, you can use the RIGHT function instead of the LEFT function in the first method.
Download Practice Workbook
Download this practice workbook to exercise while reading this article.
Conclusion
Thanks for making it this far. I hope you find this article useful. Now you know three practical examples of how to use the ISNUMBER function with IF and Then Statement in Excel. Please let us know if you have any further queries, and feel free to give us any recommendations in the comment section below.
<< Go Back to Excel ISNUMBER Function | Excel Functions | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!