This text talks about #DIV/0! error in Microsoft Excel and the best way 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 comprises no worth or is empty and you’ve got utilized a division components.
Now, there will be 0 worth in varied cells in a document. You probably have utilized a division components to a complete 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. If you’re going through the identical downside, no worries we received you lined. On this tutorial, I can be displaying you the steps to keep away from this error in MS Excel. Allow us to take a look at how one can take away #DIV/0! error out of your Excel workbook.
How you can take away #DIV/0! error in Excel
This error will 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 components. Merely click on on the cell that exhibits #DIV/0! error after which go to the capabilities field. You now have so as to add the next components:
- If you wish to return a clean worth in case of error, use
- For displaying a 0 worth rather than error, use
- You can too use an IF assertion like
=IF(C2=0,0,B2/C2)to get 0 return worth in case C2 comprises 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 complete column, you’ll have to copy the identical components to the entire column. For that, you possibly can 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 components 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 can even use the ISERROR operate. This operate principally returns TRUE worth when there may be an error, and it returns FALSE worth when there is no such thing as a error. To indicate TRUE in case of #DIV/0! error, you need to use the =ISERROR(B2/C2) components.
Hope this text helps you take away the #DIV/0! error in Microsoft Excel.
Now check out these posts:
- How you can use ROMAN operate in Excel
- Yellow Triangle with Exclamation Level in Excel or Phrase.