打开App
360P
[函数说24]逻辑或？要么要么，其中一个为真结果为真，否则为假
EXCEL必学：EXCEL函数从零开始24/42
![[函数说23]逻辑与运算是什么？多个条件同时成立为真，否则为假！](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/186c00530a9644e580eaa5bfc78eec20~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=tGEb4lgBNqttqBzcKfC12E953Gs%3D)
App04:47![[函数说24]逻辑或？要么要么，其中一个为真结果为真，否则为假](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/7856ddb546da4a46ac4b2954b515c51f~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=ZmAJQYitroEM1jtUSSDu8Ax2SaQ%3D)
App02:36![[函数25]假作真时真亦假？逻辑取反你需要了解一下！](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/c0bd1e78a85749728c323e0d4e36aad1~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=Odc%2Fgs%2FQ6Cc%2BQpc%2Ba3MUHGeOwN4%3D)
App03:28![[函数说26]人生如果有if该多好，选择什么看条件，不满意改条件吧](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/e541358ab1a44acf885a086008bd5aae~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=LTruFWTvl3wno343ytoLgIQXSHA%3D)
App05:17![[函数说27]if的嵌套应用，这只是一个开始，复杂的还在后面](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/bb1de654db7a4b7eacd60e6f72454673~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=xWkLJIzhspAIyiWQ%2Bv5yScEc3Bo%3D)
App10:53![[函数说28] 个税税率如何正确选择？if函数嵌套的综合应用](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/e9206b5ba06748ee8aff5711618db9a7~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=vBJG6SOwsGnoine6%2B3JT4xj1AuA%3D)
App10:12![[函数说29] 公式错误显示奇怪信息如何办？检测错误信息并替换它](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/c696d588c33848b29f422d54fd22cb4a~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=Mu87cCe23lpRyODqOz%2FO3Ato0uc%3D)
App03:37![[函数说31] 最大值谁不会找！哪第二大呢？你想找第几大说就完了](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/8c69ef6d1e474b9496a017cec72f4ae8~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=MPKeRSSAzj1UbBliv0HbRhUiY98%3D)
App02:34![[函数说32] 最小值你会找，哪次小值呢？这些都不是问题！](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/0be3798580e44ea5a56597b88d932580~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=d8XoOYxYrbep%2F9EscXYJVs2krlg%3D)
App01:59![[函数说33] 数据排名怎么做？排名方式和排名区域很重要！](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/07d3b7d4e4bc4ae7b76151ee8774a737~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=J8LgVhjhhGtJrRHlHdMtfDnKf4I%3D)
App03:50![[函数说30] #N/A看不懂？没有关系，换成能读懂的就人性化了！](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/56d4c8f28e0b42118b4d7bb792a3ef1c~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=aQotxTHyxTA1Wb2JNh9vrUffQDs%3D)
App04:00![[函数说34] 奇数还是偶数？两个函数一判断就出来了！](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/81fba6fd0fd54f2b8d52fefeb0869015~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=Vyk9SfWkUY1pSzJqqxw63EQcaMY%3D)
App04:34![[函数说35] 求余函数有什么用？找到规律很有用，解决实际问题！](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/bfc62d77173441eb8b37439029614fe3~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=Lw9kfSQuNazLK7WTZOUSbA177YY%3D)
App06:42![[函数说36] 身份证号码中性别判断如何进行？提取1位看奇偶就OK!](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/84266426cfc54fd2a4c1ce9f8118d425~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=RmW3%2BzORZ396yy3Zdi3TY8DA2Kc%3D)
App06:13![[函数说37] 取行号函数很简单！它可以妙用解决实际问题！](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/bac8385dbd8947be8e22baac10b09f06~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=zpex%2F9fLyruB52nAm0TXr%2BKhuTg%3D)
App03:11![[函数说38] 取列号函数功能很简单，结合其它函数显功效！](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/1cfa92c0b8a74b3fbec166482acfc229~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=bIZ2hGPWbjZiBbXpaqpb3n2HyWE%3D)
App06:18![[函数说39] 根据坐标查找值，index就像一个巡航导弹一样！](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/a81ac5a5552944bd9befbfa4a2b289db~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=b6sv%2FILkfyBEYUvKAlhGxw1idqE%3D)
App06:57![[函数说40] 位置确定函数match，确定数值所在的行或列，追踪器！](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/de9f34cf73314e16bce5a2a55d4086ca~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=exIm9YBa9mNAo4AMy42QHA7Uz0U%3D)
App06:59![[函数说41] match+index，强强结合显神威，这个案例值得您思考！](http://p26-sign.bdxiguaimg.com/tos-cn-i-0004/a0532cf687b5412aa796b9a8e7dc8681~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=g1tD%2Byo9GtZio0lDUpQJZdAeaG8%3D)
App07:25![[函数说42] 链接函数，让你随意跳转，但是格式一定要正确！](http://p3-sign.bdxiguaimg.com/tos-cn-i-0004/caf1e2b237724e5099087116c82967a2~tplv-pk90l89vgd-crop-center:576:324.jpeg?appId=3586&biz_tag=list_custom%2Fnone&channelId=0&customType=custom%2Fnone&from=704_middle_image&imageType=list&isImmersiveScene=0&is_ios=1&is_stream=0&lk3s=9d3f5bff&logId=202501040150220A92CD95ECB89C4981AE&requestFrom=704&version_code=80402&x-expires=1767462622&x-signature=qsAj6%2FTYpvUs4pc7jHmiD3E53eM%3D)
App09:31打开App观看
