How to Use “If Not Empty” Formula in Excel

Using the "If Not Empty" formula in Excel helps you perform calculations or display results only when a specific cell contains data, otherwise, it will return a blank or another specified value. You can achieve this using the IF and ISBLANK functions in Excel.

Here's how to use the "If Not Empty" formula in Excel:

1. Start by opening your Excel workbook and navigating to the worksheet where you want to apply the formula.
2. Identify the cell where you want the result to be displayed. This is where you'll enter the "If Not Empty" formula.
3. Type the following formula in that cell, replacing "A1" with the reference of the cell you want to check for emptiness, and "YourCalculation" with the calculation or result you want to display if the cell is not empty:

=IF(ISBLANK(A1), "", YourCalculation)

4. Press Enter to apply the formula. If the cell you're checking (in this case, A1) is not empty, the formula will return the specified calculation or result. If the cell is empty, the formula will return a blank cell.

For example, let's say you want to multiply the value in cell A1 by 10, but only if A1 is not empty. Here's how you can do it:

Example

1. Open your Excel workbook and navigate to the worksheet where you want to apply the formula.
2. Identify the cell where you want the result to be displayed. For this example, let's use cell B1.
3. Type the following formula in cell B1:

=IF(ISBLANK(A1), "", A1 * 10)

4. Press Enter to apply the formula. If cell A1 is not empty, cell B1 will display the result of A1 multiplied by 10. If cell A1 is empty, cell B1 will remain blank.