Understanding Excel's #NAME? Error

preview_player
Показать описание
UNDERSTAND & FIX EXCEL ERRORS: Download our free pdf
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

The #NAME? error appears when you are referring to a named range that does not exist. You may have mistyped a name or a function name or you may have referred to a text value within a formula without enclosing the text in double quotation marks.
------------------------
Рекомендации по теме
Комментарии
Автор

Why does this output #name? : =‘Tie between’+ A2+ ’ and’ +A3

mint-o
Автор

I use VBA to fill "=NA()"
but it occurs #NAME? error.

seckinbilgic