FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Select the worksheet you want to check for errors. If the worksheet is manually calculated, press F9 to recalculate. If the Error Checking dialog is not displayed, then click on the Formulas tab > Formula Auditing > Error Checking button.

Detailed explanation-2: -Type “IFERROR” and an open parenthesis in front of the formula, which is important because it sets the order of operations of the formula. Construct the IFERROR formula using the original formula as the “value” argument and add the value for the “value if error” argument like a zero or the text value of your choice.