（视频）表格错误值系列课程：错误值#NAME? 常见出错原因与解决方法
<b>视频地址1：</b>点击观看<br><br><b>视频地址2：</b>点击观看<br><br>
<b>教程难度：</b>初级<br><br>
<b>图文教程：</b><br>
<p><span style=";font-family:微软雅黑;font-size:16px"><br></span></p><p><span style=";font-family:微软雅黑;font-size:16px">#NAME?</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">是表格计算中常见的错误值。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">例如公式名称拼写错误、公式中的文本值未添加双引号、区域引用缺少冒号、</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">引用未定义的名称或已定义名称出现拼写错误</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">等，都可导致</span></span><span style=";font-family:微软雅黑;font-size:16px">#NAME?</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">错误。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/91182427459bb04b01acbb3861d16483.png" title="中间页_05.png" alt="中间页_05.png" width="800" height="450" style="width: 800px; height: 450px;"></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">本期将给大家讲解此错误值主要的出现原因和解决方法。</span></span></p><p><br></p><p><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/bccf8f501a092ee62d67745e209abab1.png" title="教程分界线.png" alt="教程分界线.png"></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">原因一：</span></span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">公式名称拼写错误导致</span></span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px">#NAME?</span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">错误</span></span></strong></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></strong></p><p><span style=";font-family:微软雅黑;font-size:16px">▪例如使用SUM函数计算产品总值。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">当公式名称拼写错误时，计算结果会返回错误值</span> </span><span style=";font-family:微软雅黑;font-size:16px">#NAME?</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><br></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/2cdfe63a643005b4395d46e746788a12.gif" title="1.gif" alt="1.gif"></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><br></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪此时我们就要仔细检查公式拼写，将公式名称拼写正确就可得出正确的计算结果。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><br></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/64555eb91e86360bc274d57663bd56fa.gif" title="2.gif" alt="2.gif"></span></p><p><span style=";font-family:微软雅黑;font-size:16px"> </span></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">原因二：</span></span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">公式中文本引用缺少双引号导致</span></span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px">#NAME?</span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">错误</span></span></strong></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></strong></p><p><span style=";font-family:微软雅黑;font-size:16px">▪</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">以此表格为例，我们想要查找表格中的某一员工工号。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">输入公式</span>=VLOOKUP(李某,A2:B6,2,FALSE)，回车确定，计算结果会返回错误值</span><span style=";font-family:微软雅黑;font-size:16px">#NAME?</span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">这是因为公式中引用了未添加双引号的文本值。</span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/526ceec46e11dfee9b90659889d831a8.gif" title="3.gif" alt="3.gif"></span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">遇到这样的情况，在文本值前后添加双引号即可修复</span></span><span style=";font-family:微软雅黑;font-size:16px"> </span><span style=";font-family:微软雅黑;font-size:16px">#NAME?</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">错误。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/5f451837df494dbfa3090518e75b98bd.gif" title="4.gif" alt="4.gif"></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"> </span></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">原因三：公式中的</span></span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">区域引用缺少冒号</span></span></strong></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></strong></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><span style="font-family: 微软雅黑; font-size: 16px;">▪</span>以此表格为例，我们想要查找表格中的某一员工工号，</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">输入公式</span>=VLOOKUP(李某,A2B6,2,FALSE)</span></p><p><span style=";font-family:微软雅黑;font-size:16px">回车确定，计算结果会返回错误值 </span><span style=";font-family:微软雅黑;font-size:16px">#NAME?</span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">这是因为公式中引用区域未添加冒号。</span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/f628ad5134a78ca6a88fa840db01103b.gif" title="5.gif" alt="5.gif"></span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪</span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">遇到这样的情况，公式中的引用区域添加冒号就可以了。</span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/760b4a925d7a6a6eece0329452006078.gif" title="6.gif" alt="6.gif"></span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"> </span></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">原因四：</span></span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">公式中引用了未定义的名称导致</span></span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px">#NAME?</span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">错误</span></span></strong></p><p><span style=";font-family:微软雅黑;font-size:16px"> </span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">在表格中使用函数公式计算</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">，可以使用公式名称管理器功能</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">，</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">对所选区域设置名称，便于输入与计算</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪例如使用SUM函数计算产品总值，</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">我们可以对产品数值区域设置名称</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">点击公式</span>-名称管理器，在弹出的窗口中，新建名称，设置为产品数值范围。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">此时再使用</span>SUM函数计算产品总值，输入公式为=SUM(总值）就可以得到</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">计算结果</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/75a6dafabb5260b5769f4df9cdda60c7.gif" title="7.gif" alt="7.gif"></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">当我们输入错误的未定义名称，</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">会显示</span></span><span style=";font-family:微软雅黑;font-size:16px">#NAME?</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">此时就需要我们检查名称拼写是否有误，或是添加新的自定义名称</span></span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p><img src="//res1.wpsacdm.cache.wpscdn.cn/images/85ddd2dc168b15d1027eb47dd69ee754.gif" title="8.gif" alt="8.gif"></p><p><br></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">以上就是</span></span><span style=";font-family:微软雅黑;font-size:16px">#NAME?</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">常见的出错原因，你学会了吗？</span></span></p>
頁:
[1]