Many friends have probably encountered this kind of situation when using Excel, that is, encountered #DIV/0! This is in the Cell of Excel, it is because there is a calculation that divides the value by 0, which makes Excel unable to calculate the value itself.
The solution is to switch from #DIV/0! that Excel displays a different value. Now it depends on what if it is divisible by 0, what will Excel display? which we can use an Excel formula named IFERROR
Example use IFERROR
If dividing by 0 where A1 is divisible by B1, Excel displays the value as 0. You can write the formula IFERROR(A1/B1,0).
0 ความคิดเห็น