Are you getting the #DIV/0! formula error #DIV/0! while working on an Excel 2013 worksheet?
Here are the steps to resolve this issue. Open excel 2013, and then open a sheet
Here on the current sheet you can see that in cell B7 and cell C7 it’s showing the #DIV/0!
Error This error is displayed by Excel when a formula
tries to divide a number by 0 or an empty cell.
On the cell B7, in the formula bar it says sum of B2 to B4 divided by value in B5.
As the value in cell B5 is 0, the error is occursing
The same issue can be seen in cell C7 To fix this, enter a numeric value greater
than 0 in B5 and C5 Now you will see that the #DIV/0! error on
this sheet has been fixed Hope this was easy to follow. Thanks for watching!