This text talks about #DIV/0! error in Microsoft Excel and methods to repair it up. The #DIV/0! error happens when a quantity is split by 0 in Excel. It additionally exhibits up when a cell accommodates no worth or is empty and you’ve got utilized a division system.
Now, there may be 0 worth in numerous cells in a file. In case you have utilized a division system to a whole column and a sure quantity needs to be mechanically divided by 0, you’ll obtain this #DIV/0! error. It makes your workbook look very untidy and disorganized. In case you are going through the identical downside, no worries we bought you lined. On this tutorial, I might be exhibiting you the steps to keep away from this error in MS Excel. Allow us to try how one can take away #DIV/0! error out of your Excel workbook.
take away #DIV/0! error in Excel
This error may be mounted through the use of the IFERROR operate in Excel. Listed below are the precise steps to repair #DIV/0! error in Microsoft Excel:
Launch Excel and open the workbook the place you’re getting this error.
Now, suppose it’s important to divide cell values within the B column by the cell values within the C column and you’ve got used the =B2/C2 system. Merely click on on the cell that exhibits #DIV/0! error after which go to the features field. You now have so as to add the next system:
- If you wish to return a clean worth in case of error, use
- For exhibiting a 0 worth instead of error, use
- You may as well use an IF assertion like
=IF(C2=0,0,B2/C2)to get 0 return worth in case C2 accommodates a zero.
Simply enter any of the above formulae to the cell giving #DIV/0! error as you favor and this error gained’t present up within the cell.
Now, to take away this error from a whole column, you’ll have to copy the identical system to the entire column. For that, you’ll be able to choose the cell, place the cursor on the backside proper of the cell, after which maintain and drag it in the direction of the tip of the column. This may apply this system to the entire column and also you gained’t obtain a #DIV/0! in any of the cells in a column.
In the same method, you may also use the ISERROR operate. This operate principally returns TRUE worth when there may be an error, and it returns FALSE worth when there isn’t any error. To point out TRUE in case of #DIV/0! error, you need to use the =ISERROR(B2/C2) system.
Hope this text helps you take away the #DIV/0! error in Microsoft Excel.
Now check out these posts:
- use ROMAN operate in Excel
- Yellow Triangle with Exclamation Level in Excel or Phrase.