You can use the **IF** function with the **ISLBANK** function in Excel to skip a cell if it is blank when performing some calculation.

For example, you could use the following syntax:

=IF(ISBLANK(A2), "", B2*C2)

This particular example will do the following:

- If cell
**A2**is blank, then simply return a blank value. - If cell
**A2**is not blank, then return cell**B2**multiplied by cell**C2**.

You can then click and drag this formula down to other cells in a column.

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

**Example: If Cell is Blank then Skip to Next Cell in Excel**

Suppose we have the following dataset in Excel that shows the number of units sold of some item and the unit price for various employees at some company:

Suppose we would like to calculate the total revenue generated by each employee by multiplying the value in the **Units** column by the value in the **Price** column, but only if the cell in the **Employee** column is not empty.

We can type the following formula into cell **D2** to do so:

=IF(ISBLANK(A2), "", B2*C2)

We can then click and drag this formula down to each remaining cell in column D:

Here is how this formula worked:

- Cell
**A2**was not empty, so the formula returned 40 * 4 = 160. - Cell
**A3**was not empty, so the formula returned 20 * 5 = 100. - Cell
**A4**was empty, so the formula skipped the calculation and moved to the next cell. - Cell
**A5**was empty, so the formula skipped the calculation and moved to the next cell.

And so on.

**Additional Resources**

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

Excel: How to Fill Blank Cells

Excel: Apply Conditional Formatting to Blank Cells

Excel: Calculate Average and Ignore Zero and Blank Cells