论坛站务软件水平考试华为认证计算机等级PMP认证思科认证Photoshop3DMAX编程语言移动开发系统运维产品运营淘宝营销办公软件Ps修图云计算大数据摄影就业

<p><img src="/Public/forum/ueditor/image/20151004/1443960521692473.jpg" alt="1443960521692473.jpg"/></p><p style="margin-top: 0px; margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 25.6000003814697px; box-sizing: border-box !important; word-wrap: break-word !important; background-color: white;"><span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 30px; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51);">iferror</span><span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 30px; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51);">函数的使用方法</span></p><p style="margin-top: 0px; margin-bottom: 0px; padding: 0px 0px 1px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 25.6000003814697px; border: none; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(0, 176, 80); box-sizing: border-box !important; word-wrap: break-word !important;">在excel中使用iferror函数可以用来判断某些内容的正确与否，正确则返回正确结果，错误则返回需要显示的信息，详细解释和用法请看下文。</span></p><p style="margin-top: 0px; margin-bottom: 0px; margin-left: 24px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; border: none; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><strong style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;"><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51); box-sizing: border-box !important; word-wrap: break-word !important;">1.<span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 9px; line-height: normal;"> &nbsp; &nbsp;</span></span><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51); box-sizing: border-box !important; word-wrap: break-word !important;">IFERROR</span><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51); box-sizing: border-box !important; word-wrap: break-word !important;">函数语法：</span></strong></p><p style="margin-top: 0px; margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; border: none; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51); box-sizing: border-box !important; word-wrap: break-word !important;">IFERROR(value, value_if_error)</span></p><p style="margin-top: 0px; margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; border: none; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51); box-sizing: border-box !important; word-wrap: break-word !important;">表示判断value的正确性，如果value正确则返回正确结果，否则返回value_if_error。</span></p><p style="margin-top: 0px; margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; border: none; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51); box-sizing: border-box !important; word-wrap: break-word !important;">其中value的错误格式有#N/A、#VALUE!、#REF!、#DIV/0!、#NUM!、#NAME?、#NULL等。</span></p><p style="margin-top: 0px; margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; border: none; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51); box-sizing: border-box !important; word-wrap: break-word !important;">详细用法请看下面实例</span></p><p style="margin-top: 0px; margin-bottom: 0px; margin-left: 24px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; border: none; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><strong style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;"><span style="margin: 0px; padding: 0px; max-width: 100%; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51); box-sizing: border-box !important; word-wrap: break-word !important;">2.<span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 9px; line-height: normal;"> &nbsp; </span></span>判断A列数字除以B列数字的正确性并返回信息</strong></p><p><img src="/Public/forum/ueditor/image/20151004/1443960563162261.jpg" alt="1443960563162261.jpg"/></p><p style="margin-top: 0px; margin-bottom: 0px; margin-left: 24px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; border: none; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><strong style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;"><span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51);">3.<span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 9px; line-height: normal;"> </span></span>在C2单元格输入公式=IFERROR(A2/B2,"错误")</strong></p><p style="margin-top: 0px; margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; white-space: pre-wrap; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 25.6000003814697px; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><strong style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important;">公式意思是判断A2/B2的值是否正确，如果正确则返回A2/B2的结果，否则返回“错误”字符。</strong></p><p><img src="/Public/forum/ueditor/image/20151004/1443960598247856.jpg" alt="1443960598247856.jpg"/></p><p><strong style="margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; white-space: pre-wrap; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51);">4.<span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 9px; line-height: normal;"> &nbsp; &nbsp;</span></span><span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51);">因为B2是0，不能做除数，所以A2/B2是错误的，返回的结果则是“错误”</span>。</strong><img src="/Public/forum/ueditor/image/20151004/1443960640339143.jpg" alt="1443960640339143.jpg"/></p><p><strong style="margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; white-space: pre-wrap; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51);">5.<span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 9px; line-height: normal;"> &nbsp; </span></span>将鼠标放在C2单元格右下角，点住下拉。</strong><img src="/Public/forum/ueditor/image/20151004/1443960668623625.jpg" alt="1443960668623625.jpg"/></p><p><strong style="margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-family: 'Helvetica Neue', Helvetica, 'Hiragino Sans GB', 'Microsoft YaHei', Arial, sans-serif; line-height: 28px; white-space: pre-wrap; box-sizing: border-box !important; word-wrap: break-word !important; background-color: rgb(255, 255, 255);"><span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-family: 微软雅黑, sans-serif; color: rgb(51, 51, 51);">6.<span style="margin: 0px; padding: 0px; max-width: 100%; box-sizing: border-box !important; word-wrap: break-word !important; font-size: 9px; line-height: normal;"> &nbsp; </span></span>拉出的所有结果我们看到，其余都可除，是可行的结果，所以返回的都是对应相除后得到的结果。</strong><img src="/Public/forum/ueditor/image/20151004/1443960699990924.jpg" alt="1443960699990924.jpg"/></p>

论坛站务软件水平考试华为认证计算机等级PMP认证思科认证Photoshop3DMAX编程语言移动开发系统运维产品运营淘宝营销办公软件Ps修图云计算大数据摄影就业