![]() ![]() Without a colon, the formula generates the #NAME? error.įor example, the formula below is trying to add the values of cells A1 through A15. When referencing a range of cells in a formula, a colon must be entered between the two cell names. Missing colon for cell range in a formula ![]() How to fix the errorĬorrecting the spelling of the function name and using a valid function fixes the issue and allows the formula to display a value in the cell. The function name TOTAL is not a valid function, resulting in the #NAME? error. Instead, it should be spelled SUM.Īnother example is the use of a function that doesn't exist in Excel. The SUMM function name is spelled incorrectly. If a function name is spelled wrong or does not exist, the #NAME? error is displayed in the cell where the formula is entered.įor example, if you entered the following formula, it would result in the #NAME? error. Missing double quotes around the text in a formula.Missing colon for cell range in a formula. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |