How to Use the IFERROR Function in Microsoft Excel (Error Handling)

preview_player
Показать описание
The IFERROR function in Microsoft Excel helps you trap and handle errors that come up when you use calculations or functions. ("VALUE!" is a possible error message that you could see.) When Excel generates an error, you can use IFERROR to perform a different action, such as to enter "Error in Calculation" in the cell.

Рекомендации по теме
Комментарии
Автор

short and simple ... perfect explanation 👍👍👍

rajeshn
Автор

What if subtract a blank cell and leaving the cell with the iferror blank?

miamited