# Use ISNUMBER Function with IF and Then Statements in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

## 3 Practical Examples to Use ISNUMBER Function with IF and Then Statements in Excel

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. Formula Breakdown
• 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. ### 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")` Formula Breakdown
• 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. ### 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. Formula Breakdown
• 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. Notes
• 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.

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

## Related Articles #### Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  