（视频）表格错误值系列课程：错误值#DIV/0! 常见出错原因与解决方法
<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">#DIV/0</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 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>0导致的计算</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">#DIV/0</span><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></p><p><br></p><p><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/bccf8f501a092ee62d67745e209abab1.png" title="教程分界线.png" alt="教程分界线.png"></p><p><span style="font-family: 微软雅黑; font-size: 16px;"><br></span></p><p><span style="font-family: 微软雅黑; font-size: 16px;">▪以此表格为例。</span><br></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">我们可见分子为</span>1，分母为0，A3/B3的计算结果显示错误值 </span><span style=";font-family:微软雅黑;font-size:16px">#DIV/0</span><span style=";font-family:微软雅黑;font-size:16px">!</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">这是因为在表格的除法运算中，分母为</span>0导致的计算错误。</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/f78420f1e00136b87829fc4b86c14d8d.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><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>IF函数来判断分母的存在。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">例如，在</span>C3单元格中输入公式=IF(B3,A3/B3,0)，可以将计算的错误结果返回0值。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">同理也可自定义返回讯息，比如返回为</span>“含有0值”、“需要修改”、“</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">计算错误</span></span><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/989ccd7a65b2c149a87af4ae107ccda0.gif" title="2.gif" alt="2.gif"></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>#DIV/0!</span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><br></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪以此成绩单为例，我们想求出低于60分同学的平均成绩，在C</span><span style=";font-family:微软雅黑;font-size:16px">4</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">单元格中输入公式</span></span><span style=";font-family:微软雅黑;font-size:16px">=AVERAGEIF(B4:B10,<60)</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">此公式的意思为使用</span>AVERAGEIF函数计算</span><span style=";font-family:微软雅黑;font-size:16px">B4:B10</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">单元格区域满足条件</span>“<60”的单元格的平均值。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">回车确定，就可看</span>C</span><span style=";font-family:微软雅黑;font-size:16px">4</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">单元格出现</span> </span><span style=";font-family:微软雅黑;font-size:16px">#DIV/0</span><span style=";font-family:微软雅黑;font-size:16px">!</span><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">错误值，这是因为在此区域中没有满足条件</span>“<60”的单元格，也就是0个单元格满足该条件。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">当求平均值时分母为</span>0时，就会出现计算错误结果为</span><span style=";font-family:微软雅黑;font-size:16px">#DIV/0</span><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/1c6aee2c64e651027ef84afe6091f02e.gif" title="3.gif" alt="3.gif"></span></p>
頁:
[1]