这篇文章谈论#DIV/0! Microsoft Excel中的错误以及如何修复它。# DIV/0！在Excel^(Excel)中将数字除以 0 时会发生错误。当单元格不包含值或为空并且您已应用除法公式时，它也会显示。

现在，记录中的各个单元格中可以有 0 值。如果您已将除法公式应用于整列并且某个数字必须自动除以 0，您将收到 # DIV/0！错误。它使您的工作簿看起来非常凌乱和杂乱无章。如果您面临同样的问题，不用担心，我们为您提供保障。在本教程中，我将向您展示在MS Excel中避免此错误的步骤。让我们看看如何删除 # DIV/0！Excel工作簿中的错误。

如何删除 # DIV/0！Excel中的错误

可以使用Excel中的^(Excel)IFERROR函数修复此错误。以下是修复 # DIV/0的确切步骤！Microsoft Excel中的错误：

启动Excel并打开出现此错误的工作簿。

现在，假设您必须将 B 列中的单元格值除以 C 列中的单元格值，并且您使用了=B2/C2公式。只需^(Simply)单击显示 # DIV/0的单元格！错误，然后转到功能框。您现在必须添加以下公式：

• 如果要在出现错误时返回空白值，请使用=IFERROR(B2/C2,“”)
• 要显示 0 值代替错误，请使用=IFERROR(B2/C2,0)
• 您还可以使用 IF 语句，例如=IF(C2=0,0,B2/C2)在 C2 包含零的情况下获取 0 返回值。

DIV/0的单元格中输入任何上述公式！你喜欢的错误，这个错误不会出现在单元格中。

现在，要从整列中删除此错误，您必须将相同的公式复制到整列。为此，您可以选择单元格，将光标放在单元格的右下角，然后按住并将其拖动到列的末尾。这会将这个公式应用于整个列，您不会收到 #DIV/0！在列中的任何单元格中。

以类似的方式，您也可以使用ISERROR函数。该函数基本上在有错误时返回TRUE值，在没有错误时返回FALSE值。在 # DIV/0的情况下显示TRUE！错误，您可以使用=ISERROR(B2/C2) 公式。

希望这篇文章可以帮助您删除 # DIV/0！Microsoft Excel中的错误。

现在看看这些帖子：^{(Now take a look at these posts:)}

• 如何在 Excel 中使用 ROMAN 函数^{(How to use ROMAN function in Excel)}
• Excel 或 Word 中带有感叹号的黄色三角形。^{(Yellow Triangle with Exclamation Point in Excel or Word.)}

How to remove #DIV/0! error in Excel

This article talks aboυt #DIV/0! error in Microsoft Excel and how to fix it up. The #DIV/0! error occurs when a number is divided by 0 in Excel. It also shows up when a cell contains no value or is empty and you have applied a division formula.

Now, there can be 0 value in various cells in a record. If you have applied a division formula to an entire column and a certain number has to be automatically divided by 0, you will receive this #DIV/0! error. It makes your workbook look very untidy and disorganized. If you are facing the same problem, no worries we got you covered. In this tutorial, I will be showing you the steps to avoid this error in MS Excel. Let us check out how you can remove #DIV/0! error from your Excel workbook.

How to remove #DIV/0! error in Excel

This error can be fixed by using the IFERROR function in Excel. Here are the exact steps to fix #DIV/0! error in Microsoft Excel:

Launch Excel and open the workbook where you are getting this error.

Now, suppose you have to divide cell values in the B column by the cell values in the C column and you have used the =B2/C2 formula. Simply click on the cell that shows #DIV/0! error and then go to the functions box. You now have to add the following formula:

• If you want to return a blank value in case of error, use =IFERROR(B2/C2,“”)
• For showing a 0 value in place of error, use =IFERROR(B2/C2,0)
• You can also use an IF statement like =IF(C2=0,0,B2/C2) to get 0 return value in case C2 contains a zero.

Just enter any of the above formulae to the cell giving #DIV/0! error as you prefer and this error won’t show up in the cell.

Now, to remove this error from an entire column, you will have to copy the same formula to the whole column. For that, you can select the cell, place the cursor at the bottom right of the cell, and then hold and drag it towards the end of the column. This will apply this formula to the whole column and you won’t receive a #DIV/0! in any of the cells in a column.

In a similar manner, you can also use the ISERROR function. This function basically returns TRUE value when there is an error, and it returns FALSE value when there is no error. To show TRUE in case of #DIV/0! error, you can use the =ISERROR(B2/C2) formula.

Hope this article helps you remove the #DIV/0! error in Microsoft Excel.

Now take a look at these posts:

• How to use ROMAN function in Excel
• Yellow Triangle with Exclamation Point in Excel or Word.

Related posts

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Excel中使用Automatic Data Type feature

• 如何编写，构建和使用VLOOKUP function在Excel

• 如何从Excel document删除Read？

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode

• 如何在Excel中使用INT and LCM Functions

• 如何在Excel中添加Country or Area Code至Phone Number List

• 如何将一列拆分为Excel中的多列

• 如何在Windows 11/10中创建Radar Chart

• 如何在Microsoft Excel worksheet中添加Trendline

• 如何在Excel中使用Duration Financial Function

• 如何在Excel工作表中Freeze and Split Panes

• 如何更改Excel worksheet Tab的颜色

• 如何在Excel中创建Organization Chart

• 如何计算Excel中的百分比increase or decrease？

• 如何在Excel中使用Rept Function

• 如何在Excel中使用DISC function