Excel 2016 for mac cell name

broken image

For example, don't type $1,000 in a formula. This can happen if you typed extra characters in a formula. For other causes and solutions, see #NAME? error. Make sure you type names correctly, enclose any text in quotation marks, or enclose sheet names in single quotation marks (').

broken image

For more information, see Correct a #VALUE! error. The source of this problem is usually related to having a mix of numeric values and text values. If you're getting errors or unexpected results with VLOOKUP, download the VLOOKUP troubleshooting tips quick reference.

broken image
broken image

Whether it's #VALUE!, #NAME! or a problem with VLOOKUP, the following information can help you correct your error. Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac More.

 

PreviousNext
Cookie Use
We use cookies to improve browsing experience, security, and data collection. By accepting, you agree to the use of cookies for advertising and analytics. You can change your cookie settings at any time. Learn More
Accept all
Settings
Decline All
Cookie Settings
Necessary Cookies
These cookies enable core functionality such as security, network management, and accessibility. These cookies can’t be switched off.
Analytics Cookies
These cookies help us better understand how visitors interact with our website and help us discover errors.
Preferences Cookies
These cookies allow the website to remember choices you've made to provide enhanced functionality and personalization.
Save