Question

In-cell-B11, insert-a-formula-that-uses-the-IFERROR-function-to-divide-the-total-sales-for-

Q1-in-cell-B8-by-the-total-sales-in-cell-G8-and-display-"Incorrect"-in-case-of-an-error..
Use an absolute reference-to-cell-G8-in-the-formula, and then fill-the-range-C11:E11-with-
the-formula-in-cell-B11

Answer 1

To divide the sales for Q1 by total sales and display "Incorrect" in case of an error, use the formula =IFERROR(B8/$G$8, "Incorrect") in cell B11 and drag it across to C11:E11.

Step-by-step explanation:

The correct answer is option to use the IFERROR function in Excel for your purpose is as follows:

=IFERROR(B8/$G$8, "Incorrect")

You will insert this formula into cell B11. This formula takes the total sales from Q1 in cell B8, attempts to divide it by the total sales in cell G8 (which is made an absolute reference by the dollar signs), and in case of any error like division by zero, it will display "Incorrect".

Once you have the formula in B11, you can then drag the fill handle (the small square at the bottom-right corner of the cell) across to fill the range C11:E11 with the same formula.

The correct answer is option IFERROR. In cell B11, enter the formula =IFERROR(B8/G8, "Incorrect"). This formula divides the total sales for Q1 in cell B8 by the total sales in cell G8. If there is no error, it will display the result of the division. However, if there is an error (such as dividing by zero), it will display the text "Incorrect".

Now, to fill the range C11:E11 with the same formula, you can select cell B11, click on the bottom right corner of the cell (the fill handle), and drag it across the range C11:E11 to automatically apply the formula to those cells.