You can use the following formula in Excel to perform some task if a cell is not empty:

=IF(A1<>"", Value_If_Not_Empty, Value_If_Empty)

This particular formula checks if cell **A1** is empty.

If it is not empty, then **Value_If_Not_Empty** is returned.

If it is empty, then **Value_If_Empty** is returned.

The following example shows how to use this formula in practice.

**Example: Use “If Not Empty” Formula in Excel**

Suppose we have the following dataset in Excel that contains information about various basketball teams:

We can use the following formula to return a value of “Team Exists” if the cell in column A is not empty.

Otherwise, we’ll return a value of “Does Not Exist”:

**=IF(A2<>"", "Team Exists", "Does Not Exist")**

The following screenshot shows how to use this formula in practice:

If the team name is not empty in column A, then “Team Exists” is returned.

Otherwise, “Does Not Exist” is returned.

If we’d like, we could also return numeric values instead of character values.

For example, we could use the following formula to return the value of the points column divided by two if the cell in column A is not empty.

Otherwise, we’ll return an empty value:

**=IF(A2<>"", B2/2, "")
**

The following screenshot shows how to use this formula in practice:

If the team name is not empty in column A, then we return the value in the points column multiplied by two.

Otherwise, we return an empty value.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

How to Replace Blank Cells with Zero in Excel

How to Replace #N/A Values in Excel

How to Ignore #VALUE! Error in Excel