You developed a sales quotation workbook that you will share with your sales staff to help them quote prices.It shows #DIV/0 in some cells where there are empty quantities in a column.Which function would handle the error and replace it with another value.
A)ERRRORRETURN
B)IFERROR
C)ERRORHANDLER
D)ERRORTRACK

Question

Quizplus · Accepted Answer

IFERROR function can handle the error and replace it with another value. This function allows you to specify the value to display if the formula returns an error.

You Developed a Sales Quotation Workbook That You Will Share