（视频）表格错误值系列课程：错误值#NUM! 常见出错原因与解决方法
<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"><span style="font-family:微软雅黑"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">我们在表格计算的过程中，有时计算结果会出现</span> </span><span style=";font-family:微软雅黑;font-size:16px">#N</span><span style=";font-family:微软雅黑;font-size:16px">UM!错误值。</span></p><p><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;">多次迭代仍未求到结果</span><span style="font-family: 微软雅黑; font-size: 16px;">，也会导致</span><span style="font-family: 微软雅黑; font-size: 16px;"></span><span style="font-family: 微软雅黑; font-size: 16px;">#N</span><span style="font-family: 微软雅黑; font-size: 16px;">UM!</span><span style="font-family: 微软雅黑; font-size: 16px;"></span><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><span style=";font-family:微软雅黑;font-size:16px"></span><span style="font-family: 微软雅黑; font-size: 16px;">#N</span><span style="font-family: 微软雅黑; font-size: 16px;">UM!</span><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="https://res1.wpsacdm.cache.wpscdn.cn/images/bccf8f501a092ee62d67745e209abab1.png" title="教程分界线.png" alt="教程分界线.png"></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"></span></strong><strong style="white-space: normal;"><span style="font-family: 微软雅黑; font-size: 16px;">#N</span></strong><strong style="white-space: normal;"><span style="font-family: 微软雅黑; font-size: 16px;">UM!</span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px">错误</span></strong></p><p><span style=";font-family:微软雅黑;font-size:16px"> </span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪以此表格为例，数值1为500，数值2为581。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">我们想计算</span>500的581次方，输入公式=A3^B3，表示A3单元格的B3次方。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">此时显示</span></span><span style=";font-family:微软雅黑;font-size:16px">#N</span><span style=";font-family:微软雅黑;font-size:16px">UM！错误，这是因为计算结果数字太大，导致计算错误。</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/27c73125d9d8c1b8d75cb09f15e439cd.gif" title="1.gif" alt="1.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">#N</span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px">UM!错误</span></strong></p><p><span style=";font-family:微软雅黑;font-size:16px"> </span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪以此表格为例，我们想计算A3单元格的平方根数。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">输入公式</span>=SQRT(A3)，此公式的意思是计算A3单元格的平方根数。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">回车确定，显示</span></span><span style=";font-family:微软雅黑;font-size:16px">#N</span><span style=";font-family:微软雅黑;font-size:16px">UM！错误。</span></p><p><br></p><p><img src="//res1.wpsacdm.cache.wpscdn.cn/images/3935b39a5a463d8e107d6f4e0de4eab9.gif" title="2.gif" alt="2.gif"></p><p><br></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">这是因为</span>A3单元格的参数为负数，而负数无法计算平方根数，当公式中引用了无效参数时，计算结果会显示为</span><span style="font-family: 微软雅黑; font-size: 16px;">#N</span><span style="font-family: 微软雅黑; font-size: 16px;">UM!</span><span style=";font-family:微软雅黑;font-size:16px">错误。</span></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px"><br></span></strong></p><p><strong><span style="font-family: 微软雅黑;font-size: 16px">原因三：</span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px">使用迭代计算RATE 和IRR函数，会显示</span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px">#N</span></strong><strong><span style="font-family: 微软雅黑;font-size: 16px">UM！错误</span></strong><br></p><p><br></p><p><span style=";font-family:微软雅黑;font-size:16px">▪迭代计算是数值计算中较为常见的计算方法.</span></p><p><span style=";font-family:微软雅黑;font-size:16px">当使用IRR函数和RATE 函数计算利率时，函数经过多次迭代计算，仍未求到结果，此时会返回错误值</span><span style=";font-family:微软雅黑;font-size:16px">#N</span><span style=";font-family:微软雅黑;font-size:16px">UM！</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/ef6edd56710ed62e98f5a195301144d1.gif" title="3.gif" alt="3.gif"></span></p><p><span style=";font-family:微软雅黑;font-size:16px"> </span></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></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/f45fd48de4f964c4916ed6c1a35123cc.gif" title="4.gif" alt="4.gif"></span></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">#N</span><span style=";font-family:微软雅黑;font-size:16px">UM！</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>
頁:
[1]