![]() #NUM Error: The #NUM! error occurs when a formula contains an invalid number.For example, if you have a named range called “Expenses” and you accidentally type “s” at the end of your formula, you’ll get the #NAME? error #NAME Error: This error occurs when a formula contains an invalid name.For example, if you have a formula that adds two cells and one of the cells contains text instead of a number, you’ll get this error. #VALUE Error: This error occurs when a formula contains an invalid value. ![]() #REF! Error: You will get this error message when a formula contains an invalid cell reference for example, if you have a formula that references cells B15:B25 and delete row 24, the formula will return the #REF! Error because it no longer has a valid reference. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |