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!
Note: Commissions may be earned from the links above.
This page contains references to products from one or more of our advertisers. We may receive compensation when you click on links to those products. For an explanation of our advertising policy, please visit this page.