The IFERROR function in Excel handles all error types including #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.You can also display your own message instead of Excel's standard error notation:ĥ things you should know about Excel IFERROR function Supply an empty string (") to the value_if_error argument to return a blank cell if an error is found: To prevent that from happening, use the IFERROR function to catch and handle errors the way you want. It can be an empty string (blank cell), text message, numeric value, another formula or calculation.įor example, when dividing two columns of numbers, you may get a bunch of different errors if one of the columns contains empty cells, zeros or text. Value_if_error (required) - what to return if an error is found.It can be a formula, expression, value, or cell reference. Value (required) - what to check for errors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |