For this purpose IFERROR function is used to manage such errors. When you don’t want to show these returning errors as result of a formula in your data then Excel has a way to return an alternate value or custom value or blank cell. When formula contains invalid numeric values (#NUM!).When an incorrect range operator is used in formula (#NULL!).When you use invalid cell references in formula (#REF!).When you divide a number by zero or an empty cell (#DIV/0!). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |