# Excel: Use IF Function to Check if Cell is a Number

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.