How to remove #DIV/0 errors in excel
excel, excel-formula
Solution
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)
Problem
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) ```