113k views
2 votes
In cell M11, enter a formula that will calculate the total amount due after discounts have been 10 applied. Incorporate an IFERROR function to retum a blank value (") if formula returns an error. Format the result as Accounting and copy the formula down through M34

User Sivanes
by
8.2k points

2 Answers

1 vote

Final answer:

The Excel formula required in cell M11 should use the IFERROR function to provide a blank result if an error occurs and should be formatted as Accounting. The exact formula used for the calculation would depend on the details of the price and discount information.

Step-by-step explanation:

To calculate the total amount due after discounts in cell M11 and handle any errors that might occur during the calculation, you would use an Excel formula with the IFERROR function. This function allows for a cleaner presentation of data by returning a specified value (in this case, a blank value) if an error is encountered.

The formula might look something like this:

=IFERROR(YourFormulaHere, "")

However, without the specific details of the formula you're using for the calculation (like 'YourFormulaHere'), it's impossible to provide the exact formula you need to enter. Typically, this formula would reference other cells that contain the price and discount information. Make sure to format the result as Accounting in Excel to align the currency symbol and the decimal point.

After entering the formula in cell M11, you would copy it down to cell M34 to apply it to all rows in that range.

User Smartkid
by
8.8k points
3 votes

Final answer:

To calculate the total amount due after a 10% discount and format it as Accounting, you can use an IFERROR function.

Step-by-step explanation:

In cell M11, enter the formula to calculate the total amount due after applying a discount of 10%. To incorporate the IFERROR function, you can use the formula:

=IFERROR(B11*(1-0.10), "")

Where B11 is the cell containing the original amount. This formula will calculate the new amount after the discount has been applied. To format the result as Accounting, you can select cell M11 and choose the Accounting format from the format options. Finally, copy the formula down through M34 to apply it to the entire range of cells.

User Baj Mile
by
7.8k points