Excel Divide By Zero Error - Mass Update

Question

I have an existing workbook that I am updating, and it has a lot of #DIV/0! errors. Is there a quick way that I can correct all of them (or at least a lot at once)? Adding an =If statement to every individual cell would take forever!

More info:

All of the #DIV/0! errors come from cells where I have a formula that is dividing the values of two different cells i.e. =cll/c12. In a lot of these cases, the denominator is zero, so it gives the error. I am looking for a fast way to correct several thousand of these errors without having to manually add error checking to each cell.

Answer 1

From the little information I gathered from the question

You can perform a Find and Replace

• Hit CtrlH to bring up the Find and Replace screen

Updated:

Step 1: Select the range that you will work with.

Step 2: Press the F5 key to open the Go To dialog box.

Step 3: Click the Special button, and it opens the Go to Special dialog box.

Step 4: In the Go to Special dialog box, only check the Errors option

Step 5: And then click OK, all # formula errors have been selected

Step 6: Now just enter 0 or any other value that you need to replace the errors, and press Ctrl + Enter keys. Then you will get all selected error cells are filled with 0 or your formula

Of course, you can delete all of error cells with pressing the Delete key, leaving the blank cells.

Screenshots and Src