Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

Use ISNUMBER Function with IF and Then Statements in Excel

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.


Download Practice Workbook

Download this practice workbook to exercise while reading this article.


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.

excel if isnumber then


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.

excel if isnumber then

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.

AutoFill Formula to Investigate If a Cell Starts with Number

Read More: How to Use COUNTIF & ISNUMBER to Count Numbers in Excel


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")

Use ISNUMBER Function with IF and Then Statements in Excel to Check If a Cell Value is a Number

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.

AutoFill formula to Check If a Cell Value is a Number

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.

Use ISNUMBER Function with IF and Then Statements in Excel to Look for a Text in a Cell

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.

AutoFill Formula to Look for a Text in a Cell

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.

Read More: How to Use ISEVEN Function in Excel (2 Suitable Examples)


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

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

Leave a reply

ExcelDemy
Logo