How to remove #DIV/0! and zero values in Excel?

When creating a table, with data and then calculations on this data in Excel, we can obtain cases with the value zero or the famous message #DIV/0! which can be annoying later to have an average, a median, etc …

There are two solutions:

You go to File > Options > Advanced > Display options for this sheet, and then uncheck:

– Show a zero in cells that have a zero value.

Or you use the following formula in your calculation:


Where D297 is a value in a left column and E297 is a value in a right column. The result is the disappearance of zeros and #DIV/0!


Leave a Reply

Be the First to Comment!

Notify of