Excel: A Simple Formula for “If Not Empty”


You can use the following formula in Excels 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:

Excel formula for "if not empty"

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 Google Sheets:

How to Filter for Cells that Contain Text in Google Sheets
How to Extract Substring in Google Sheets
How to Extract Numbers from String in Google Sheets

Leave a Reply

Your email address will not be published.