IFERROR Function

This logical function is present in both Microsoft Excel and Google Sheets. It allows you to handle certain types of formula errors, such as divide by zero errors, in a friendly fashion by allowing you to define the error text. When used in a formula, it will either return the value or evaluate the error.