In this tutorial, you will learn how to use “if not empty” formula in Excel.

You can use a formula based on the IF function to test numerous cells and return the value from the first non-blank cell.

Once ready, we’ll get started by utilizing real-world examples to show you how to use “if not empty” formula in Excel.

Table of Contents

## Use “If Not Empty” Formula

Before we begin we will need a group of data to use “if not empty” formula in Excel.

### Step 1

First, you need to have a clean and tidy group of data to work with.

### Step 2

In this example, we want to find out if the students attended the exam. To do so, we need to insert the following formula =IF(B2<>””, “Attended”, “Absent”).

### Step 3

Once you are done, you will be able to use “if not empty” formula in Excel.