In this tutorial, you will learn how to ignore blank cells when using formulas in Excel.
Once ready, we’ll get started by utilizing real-world examples to show you how to ignore blank cells when using formulas in Excel.
Table of Contents
Ignore Blank Cells When Using Formulas in Excel
Before we begin we will need a group of data to ignore blank cells when using formulas 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 calculate only the students with scores and ignore those without scores. To do so, we can simply insert the following formula =IF(B2<>””, B2+C2, “”).
Step 3
Once we are done, the formula pulled downwards only return cells that are not blank.
