id: 947b5241da08446f918f18d544b4fc30
parent_id: 
item_type: 1
item_id: 410d8374844342f0b9a8f70d7e65e78c
item_updated_time: 1764345493412
title_diff: "[{\"diffs\":[[1,\"IF函数的8个公式\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":9}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>IF函数的8个公式</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"22678\\\"></a>\\\r\\\n<h1>IF函数的8个公式</h1>\\\r\\\n\\\r\\\n<div><span>\\\n  <div style=\\\"--en-clipped-content:article; --en-clipped-source-url:https://mp.weixin.qq.com/s/sNWAKissuzXMI2zT-sJPsw; --en-clipped-source-title:IF函数的8个公式;\\\">\\\n<div><br/></div><div style=\\\"font-size: 16px; display:block; min-width: 100%; position: relative;\\\"> <div style=\\\"color:rgb(211, 209, 207);line-height:1.6;text-size-adjust:100%;-webkit-appearance:none;-webkit-tap-highlight-color:rgba(211, 209, 207, 0);background-color:rgb(33, 35, 36);\\\"><div style=\\\"letter-spacing:0.034em;color:rgba(211, 209, 207, 0.6);background-color:rgb(24, 25, 25);font-size:16px;font-family:-apple-system-font, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei UI&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif;line-height:1.6;-webkit-appearance:none;-webkit-tap-highlight-color:rgba(211, 209, 207, 0);\\\"><div><div style=\\\"overflow-wrap:break-word;\\\"><div style=\\\"background-color:rgb(29, 30, 31);\\\"><div><div>\\\n                \\\n                <h2 style=\\\"padding:0px;margin:0px;line-height:1.4;margin-bottom:14px;font-size:22px;font-weight:700;\\\">\\\n                    \\\n                    \\\n                    \\\nIF函数的8个公式\\\n                </h2>\\\n                <div style=\\\"margin:0px;padding:0px;margin-bottom:22px;line-height:20px;font-size:0px;overflow-wrap:break-word;position:relative;z-index:1;\\\">\\\n                                                                                                                <span style=\\\"padding:0px;display:inline-block;vertical-align:middle;font-size:15px;margin:0px 10px 10px 0px;-webkit-tap-highlight-color:rgba(211, 209, 207, 0);color:rgba(211, 209, 207, 0.3);\\\">\\\n                                                                    Excel精英培训\\\n                                                            </span>\\\n                                                                \\\n                                        <span style=\\\"padding:0px;display:inline-block;vertical-align:middle;font-size:15px;position:relative;margin:0px 10px 10px 0px;-webkit-tap-highlight-color:rgba(211, 209, 207, 0);\\\">\\\n                      <a href=\\\"#\\\" style=\\\"margin:0px;padding:0px;-webkit-tap-highlight-color:rgba(211, 209, 207, 0);text-decoration:none;color:rgb(153, 146, 136);text-decoration-color:initial;cursor:pointer;\\\">\\\n                        Excel精英培训                      </a>\\\n                      \\\n                    </span>\\\n                    <em style=\\\"padding:0px;font-style:normal;display:inline-block;vertical-align:middle;font-size:15px;margin:0px 10px 10px 0px;-webkit-tap-highlight-color:rgba(211, 209, 207, 0);color:rgba(211, 209, 207, 0.3);\\\">6天前</em>\\\n                </div>\\\n\\\n                \\\n                                \\\n                <div style=\\\"margin:0px;padding:0px;\\\">\\\n                                    </div>\\\n                \\\n\\\n                \\\n                                                                \\\n\\\n                \\\n                                \\\n\\\n\\\n                \\\n                \\\n                \\\n                \\\n                                                \\\n                                                                \\\n                                \\\n                                \\\n                \\\n                <div style=\\\"margin:0px;padding:0px;overflow:hidden;font-size:17px;overflow-wrap:break-word;text-align:justify;z-index:0;color:rgba(211, 209, 207, 0.6);position:relative;visibility:visible;\\\">\\\n                    \\\n\\\n                    \\\n\\\n                    \\\n                    \\\n                    <p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">IF函数是工作中最常用的函数之一，所以兰色今天决定用一篇文章把IF函数的使用方法再梳理一番。看过你会不由感叹：原来IF函数也可以玩的这么高深！！</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\"><strong style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\"><span style=\\\"color:rgb(118, 146, 60);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;--darkreader-inline-color:#a0b671;visibility:visible;\\\">一、IF函数的使用方法（入门级）</span></strong></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"color:rgb(0, 112, 192);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#49a5e7;visibility:visible;\\\">1、单条件判断返回值</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">=IF(A1&gt;20,&quot;完成任务&quot;,&quot;未完成&quot;)</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"color:rgb(0, 112, 192);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#49a5e7;visibility:visible;\\\">2、多重条件判断</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">=IF(A1=&quot;101&quot;,&quot;现金&quot;,IF(A1=&quot;1121&quot;,&quot;应收票据&quot;，IF(A1=1403,&quot;原材料&quot;)))</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">注：<span style=\\\"color:rgb(49, 133, 155);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;--darkreader-inline-color:#69adbf;visibility:visible;\\\">多条件判断时，注意括号的位置，右括号都在最后，有几个IF就输入几个右括号。</span></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"color:rgb(0, 112, 192);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#49a5e7;visibility:visible;\\\">3、多区间判断</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">=IF(A1&lt;60,&quot;不及格&quot;,IF(A1&lt;80,&quot;良好&quot;,&quot;优秀&quot;))</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">=IF(A1&gt;=80,&quot;优秀&quot;,IF(A1&gt;=60,&quot;良好&quot;,&quot;不及格&quot;))</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">注：<span style=\\\"color:rgb(49, 133, 155);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;--darkreader-inline-color:#69adbf;visibility:visible;\\\">IF在进行区间判断时，数字一定要按顺序判断，要么升要不降。</span></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"color:rgb(118, 146, 60);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#a0b671;visibility:visible;\\\"><strong style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\">二、IF函数的使用方法(进阶)</strong></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"color:rgb(0, 112, 192);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#49a5e7;visibility:visible;\\\">4、多条件并列判断</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">=IF(AND(A1&gt;60,B1&lt;100),&quot;合格&quot;,&quot;不合格&quot;)</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">=IF(OR(A1&gt;60,B1&lt;100),&quot;合格&quot;,&quot;不合格&quot;)</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;visibility:visible;\\\">注：<span style=\\\"color:rgb(49, 133, 155);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;--darkreader-inline-color:#69adbf;visibility:visible;\\\">and()表示括号内的多个条件要同时成立</span></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><span style=\\\"color:rgb(49, 133, 155);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#69adbf;visibility:visible;\\\">or()表示括号内的多个条件任一个成立</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;visibility:visible;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;visibility:visible;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"color:rgb(0, 112, 192);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#49a5e7;\\\">5、复杂的多条件判断</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">=IF(OR(AND(A1&gt;60,B1&lt;100),C1=&quot;是&quot;),&quot;合格&quot;,&quot;不合格&quot;)</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">=IF(ADN(OR(A1&gt;60,B1&lt;100),C1=&quot;是&quot;),&quot;合格&quot;,&quot;不合格&quot;)</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"color:rgb(0, 112, 192);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#49a5e7;\\\">6、判断后返回区域</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">=VLOOKUP(A1,IF(B1=1,C:D,F:G),2,0)</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">注：<span style=\\\"color:rgb(49, 133, 155);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;--darkreader-inline-color:#69adbf;\\\">IF函数判断后返回的不只是值，还可以根据条件返回区域引用。</span></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\"><strong style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;\\\"><span style=\\\"color:rgb(79, 97, 40);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;--darkreader-inline-color:#b2c28e;\\\">三、IF函数的使用方法（高级）</span></strong></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"color:rgb(0, 112, 192);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#49a5e7;\\\">7、IF({1,0}结构</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">=VLOOKUP(A1,IF({1,0},C1:C10,B1:B10),2,0)</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">{=VLOOKUP(J15&amp;K15,IF({1,0},A1:A2&amp;B1:B2,C1:C2),2,0)}</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">注：<span style=\\\"color:rgb(49, 133, 155);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;--darkreader-inline-color:#69adbf;\\\">利用数组运算返回数组的原理，IF（{1,0}也会返回一个数组，即当第一个参数为1时的结果放在第1列，为0时的结果放在数组第二列。</span></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"color:rgb(0, 112, 192);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;--darkreader-inline-color:#49a5e7;\\\">8、N(IF( 和 T(IF(</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">{=SUM(VLOOKUP(T(IF({1,0},J15,K15)),E15:G17,3,0))}</span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><span style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;font-size:15px;\\\">注:<span style=\\\"color:rgb(49, 133, 155);margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;--darkreader-inline-color:#69adbf;\\\">vlookup函数第一个参数不能直接使用数组，借用t(if结构可以转换成内存数组。</span></span></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;\\\"/></p><p style=\\\"background-color:rgb(255, 255, 255);color:rgb(62, 62, 62);padding:0px;margin:0px;max-width:100%;box-sizing:border-box !important;overflow-wrap:break-word !important;clear:both;min-height:1em;letter-spacing:0.544px;white-space:normal;font-size:16px;line-height:25.6px;--darkreader-inline-color:#b2ada6;--darkreader-inline-bgcolor:#212324;\\\"><br style=\\\"margin:0px;padding:0px;max-width:100%;box-sizing:border-box;overflow-wrap:break-word;\\\"/></p>\\\n                </div>\\\n\\\n                \\\n\\\n                \\\n\\\n\\\n\\\n                \\\n                \\\n\\\n                 \\\n                                                    \\\n                              \\\n            </div></div></div></div></div></div></div></div>\\\n</div>\\\n</span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":30499}]"
metadata_diff: {"new":{"id":"410d8374844342f0b9a8f70d7e65e78c","parent_id":"061de1401cfc4cfaadf6e74e015970e9","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764345729851,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T16:12:44.473Z
created_time: 2025-11-28T16:12:44.473Z
type_: 13