# If Cell is Blank Then Show 0 in Excel (4 Ways)

We have a dataset with production information of different factories. A unit is considered ready to sell when packaging is done. In the Unit Ready to sell column (column E) we want to show 0 if any cell in the Unit Packaged column (column D) of the same row is blank.

## If Cell Is Blank, Then Show 0 in Excel: 4 Ways

### Method 1 – IF Function to Show 0 in Blank Cell

• Use the following formula in cell E6,
`=IF(D6="",0,D6)`

The formula will show 0 in E6 if D6 is empty. Otherwise, it will show the value of D6 in E6.

• Press Enter and drag the cell E6 down to apply the same formula in all other cells of column E.

### Method 2 – ISBLANK Function to Display 0

• Use the following formula in cell E6,
`=IF(ISBLANK(D6),0,D6)`

• Press Enter and drag the Fill Handle down to AutoFill the column.

Read More: How to Return Value If Cell is Blank

### Method 3 – Replacing a Blank Cell with 0 Using Go to Special

• Select your dataset and go to Editing, then choose Find & Select and pick Go To Special.

• The Go To Special window will appear.
• Select Blanks and click on OK.

• All of the blank cells will be selected.

• Type 0 and press Ctrl + Enter.

### Method 4 – Display 0 in Blank Cells from Display Options

• Go to the Home tab and select Options.

• Select Advanced and check the box Show a zero in cells that have zero value.
• Click on OK.

• You will see the cells without a value are showing 0 instead of being blanks.

## Related Articles

<< Go Back to If Cell is Blank Then | Excel Cells | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF