Question

error is displayed when the text is not recognized in a formula​

Answer 1

Answer:

error occurs when Excel does not recognize text in a formula. 1. Simply correct SU to SUM.

Answer 2

Answer:

Summary. The Excel IFERROR function returns a custom result when a formula generates an error, and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements. Trap and handle errors. The value you specify for error conditions.