如何清除Excel中的#DIV/0错误 [英] How to remove #DIV/0 errors in excel

问题描述

我正在尝试删除DIV错误或将其替换为空白，并且我尝试使用ISERROR函数，但仍然无法正常工作.这就是我的数据:

I am trying to remove or replace the DIV error with blank and i have tried to use the ISERROR function but still does not work. This is what it looks like my data:

       COLA  COLB   COLC
ROW1    $0    $0   #DIV/0
ROW2               #VALUE!

因此，当我遇到上述类似问题并且想要替换为空白时，我会遇到此类错误.这是我的公式不起作用.谢谢

so i get these kind of errors when i have something like above and i would like to replace with blanks. Here is my formula that does not work. thanks

=IF((ISERROR(D13-C13)/C13),"",(D13-C13)/C13)

推荐答案

这些建议都是有效的.您的原始公式不起作用的原因是圆括号的位置错误.试试

The suggestions are all valid. The reason why your original formula does not work is the wrong placement of the round brackets. Try

=IF(ISERROR((D13-C13)/C13),"",(D13-C13)/C13)

这篇关于如何清除Excel中的#DIV/0错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！