IFERROR

Replace expected formula errors with a useful fallback message or value.

Practical example

=IFERROR(A2/B2, 0)

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.

Continue into guided Excel practice