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!