Question: why iferror formula is used?
Answer: The IFERROR function "catches" errors in a formula and returns an alternative result or formula when an error is detected. Use the IFERROR function to trap and handle errors produced by other formulas or functions. IFERROR checks for the following errors: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.