You can use the following formulas to use an IF function to check if a cell contains a number in Excel:
Method 1: Check if Cell is a Number
=IF(ISNUMBER(A2), "Yes", "No")
This formula returns Yes if the value in cell A2 is a number. Otherwise it returns No.
Method 2: Check if Cell Contains Any Numbers
=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0, "Yes", "No")
This formula returns Yes if cell A2 contains any number. Otherwise it returns No.
Method 3: Check if Cell is Equal to Specific Number
=IF(A2=100, "Yes", "No")
This formula returns Yes if cell A2 is equal to the number 100. Otherwise it returns No.
The following examples show how to use each formula in practice with the following dataset in Excel:
Example 1: Check if Cell is a Number
We can type the following formula into cell B2 to return “Yes” if the value in cell A2 is a number or return “No” otherwise:
=IF(ISNUMBER(A2), "Yes", "No")
We can then click and drag this formula down to each remaining cell in column B:
The formula returns “Yes” if the corresponding cell in column A is a number or “No” otherwise.
Example 2: Check if Cell Contains Any Numbers
We can type the following formula into cell B2 to return “Yes” if the value in cell A2 contains any numbers or return “No” otherwise:
=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2))>0, "Yes", "No")
We can then click and drag this formula down to each remaining cell in column B:
The formula returns “Yes” if the corresponding cell in column A contains any numbers or “No” otherwise.
Example 3: Check if Cell is Equal to Specific Number
We can type the following formula into cell B2 to return “Yes” if the value in cell A2 is equal to the number 100 or return “No” otherwise:
=IF(A2=100, "Yes", "No")
We can then click and drag this formula down to each remaining cell in column B:
The formula returns “Yes” if the corresponding cell in column A is equal to 100 or “No” otherwise.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Excel: How to Use IF Function with Multiple Conditions
Excel: How to Create IF Function to Return Yes or No
Excel: How to Use an IF Function with Range of Values
