We can display a Zero instead of #DIV/0! Error as follows: First, create a data table, as shown below. Next, choose cell B3 → select the “Formulas” tab → go to the “Function Library” group → click the “Insert Function” option on the far left, as shown below. The “Insert Function” window appears. In the “select a category:” drop-down, select the “Logical” option, as shown below. Now, the options change in the “Select a function:” group, then select the IF function, and close “OK”, as shown below. Once we click “OK” in the “Insert Function” window, the Function Arguments window appears. Enter in the Logical_test field as A2=0, the Value_if_true field blank, the Value_if_false field as B2/A2, and click “OK”, as shown below. So the complete formula will be =IF(A2=0,,B2/A2). We will get the result ‘0’, as shown below.