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.

Table of Contents hide

Download Practice Workbook

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

Example 1: Investigate If a Cell Starts with Number

Example 2: Check If a Cell Value is a Number

Example 3: Look for a Text in a Cell

Conclusion

Download Practice Workbook

Download this practice workbook to exercise while reading this article.

ISNUMBER Function with IF and Then Statements.xlsx

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.

Similar Readings

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.

Read More: [Fixed!] ISNUMBER Is Not Working in Excel

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.