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