f9yx0du 发表于 2024-10-1 14:34:39

运用Excel时把握了这4种IF函数用法，再亦不怕各样需要判断问题了


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">大众</span>好！我是【桃大喵学习记】，点击右上方“关注”，<span style="color: black;">每日</span>为你分享职场办公软件<span style="color: black;">运用</span>技巧干货！</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>平时在<span style="color: black;">运用</span>Excel表格处理数据时，难免会遇到<span style="color: black;">各样</span><span style="color: black;">要求</span>判断的问题。今天笔者就跟<span style="color: black;">大众</span>分享以下4种IF函数的用法，<span style="color: black;">熟悉</span><span style="color: black;">把握</span>后灵活应用<span style="color: black;">能够</span>帮你<span style="color: black;">处理</span>平时工作中的<span style="color: black;">各样</span><span style="color: black;">要求</span>判断问题。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、IF函数常规单<span style="color: black;">要求</span>判断</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">公式:=IF(B2&gt;=70,"达标","不达标")</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">按照</span>B2考核成绩<span style="color: black;">要求</span><span style="color: black;">规律</span>判断，大于70返回达标，否则返回不达标</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/d0d23fbcc8cf41ef8a1cd4a2cc9020e0~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968628&amp;x-signature=ltamiKk14dEBJDN0Q6Fn3B74DaU%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、IF函数多<span style="color: black;">要求</span>判断，<span style="color: black;">规律</span>或的关系</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">公式：=IF((C2&gt;90)+(D2&gt;=6),"是","否")</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">IF函数多<span style="color: black;">要求</span><span style="color: black;">规律</span>或关系，<span style="color: black;">便是</span>有2个<span style="color: black;">或</span>多个<span style="color: black;">要求</span>，这些<span style="color: black;">要求</span>是<span style="color: black;">规律</span>或的关系，只要有一个<span style="color: black;">要求</span>成立，<span style="color: black;">那样</span>返回的值<span style="color: black;">便是</span>真True，除非所有<span style="color: black;">要求</span>都不成立才返回假False</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">例如</span>以学生英文成绩为例，当英语成绩大于90分<span style="color: black;">或</span>进步名次大于等于6名，就<span style="color: black;">能够</span><span style="color: black;">得到</span>优秀奖，只要满足一个<span style="color: black;">要求</span>就<span style="color: black;">能够</span><span style="color: black;">得到</span>优秀奖</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/01168c52cfbd45dca2ffc0a54a2efc3f~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968628&amp;x-signature=MvWf0mTRNNEJAuL1GGNoiCB7Mzw%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、IF函数多<span style="color: black;">要求</span>判断，<span style="color: black;">规律</span>且的关系</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">公式：=IF((C2&gt;=90)*(D2&gt;=90)*(E2&lt;=1),800,0)</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">IF函数多<span style="color: black;">要求</span><span style="color: black;">规律</span>且关系，<span style="color: black;">便是</span>有2个<span style="color: black;">或</span>多个<span style="color: black;">要求</span>，这些<span style="color: black;">要求</span>是<span style="color: black;">规律</span>且的关系，需要多个<span style="color: black;">要求</span><span style="color: black;">同期</span>成立才返回真True，否则都会返回假False</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">例如</span>以<span style="color: black;">机构</span>考核奖金为例，当季度考核成绩大于等于90，出勤率大于等于90，并且投诉次数<span style="color: black;">少于</span>等于1次时，员工<span style="color: black;">才可</span><span style="color: black;">得到</span>季度奖金800元。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/8b2a0f05562d4dbe81263c2402a48fe6~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968628&amp;x-signature=C68GIQWoHBMM3p111ChzgMF0BXQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">4、IF函数多<span style="color: black;">要求</span>嵌套</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">IF函数多<span style="color: black;">要求</span>嵌套比上面三种<span style="color: black;">状况</span>难<span style="color: black;">有些</span>，<span style="color: black;">能够</span>用于等级判定、提成计算等这些场景下，<span style="color: black;">便是</span>将多个IF<span style="color: black;">要求</span>嵌套后得到对应结果。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">=IF(C2&gt;=80,"20000",IF(C2&gt;=70,"15000",IF(C2&gt;=60,"10000","8000")))</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">下面就以<span style="color: black;">机构</span>员工<span style="color: black;">营销</span>业绩为了，当大于等于80万，奖金20000元；当大于等于70万<span style="color: black;">少于</span>80万奖金15000元；当大于等于60万<span style="color: black;">少于</span>70万奖金10000元；<span style="color: black;">营销</span>业绩<span style="color: black;">少于</span>60万的奖金是8000元。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/e17438489ebb4fcca78072bd78b92bb7~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968628&amp;x-signature=nzgklzUNoFYhyfK6%2FSC8Z67QsVg%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">IF函数多<span style="color: black;">要求</span>嵌套<span style="color: black;">规律</span>解释：</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">第1</span>层IF函数：</strong><span style="color: black;">倘若</span>业绩&gt;=80，<span style="color: black;">要求</span>是真，就返回<span style="color: black;">第1</span>层函数的第二个参数；<span style="color: black;">倘若</span>业绩&lt;80，<span style="color: black;">那样</span><span style="color: black;">要求</span>就为假，就会返回<span style="color: black;">第1</span>层IF函数的第三参数，而<span style="color: black;">第1</span>层IF函数的第三参数正好是第二层IF函数，<span style="color: black;">因此</span>就会进继续向下判断</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">第二层IF函数：</strong><span style="color: black;">倘若</span>80&gt;业绩&gt;=70，第二层IF<span style="color: black;">要求</span>是真，就会返回第二层IF的第二参数；<span style="color: black;">倘若</span>业绩&lt;70,第二层IF函数<span style="color: black;">要求</span><span style="color: black;">便是</span>假，就会返回第二层IF函数的第三参数，第三个参数正好是第三层IF函数，就会继续向下判断</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">第三层IF函数：</strong><span style="color: black;">倘若</span>业绩70&gt;业绩&gt;=60，<span style="color: black;">要求</span>位真，就会返回第三层IF的第二个参数，否则就会返回第三层IF的第三个参数。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上<span style="color: black;">便是</span>今天分享的在<span style="color: black;">运用</span>Excel时常遇到的4种IF函数用法，<span style="color: black;">熟悉</span><span style="color: black;">把握</span>后再<span style="color: black;">亦</span>不怕<span style="color: black;">各样</span><span style="color: black;">要求</span>判断问题了，超级实用<span style="color: black;">意见</span><span style="color: black;">保藏</span>哦！</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上是【桃大喵学习记】今天的干货分享~觉得内容对你有<span style="color: black;">帮忙</span>，记得顺手点个赞哟~。我会经常分享职场办公软件<span style="color: black;">运用</span>技巧干货！<span style="color: black;">大众</span>有什么问题欢迎留言关注噢~</p>




b1gc8v 发表于 2024-10-25 13:49:36

你的见解真是独到，让我受益良多。

j8typz 发表于 2024-11-12 05:31:51

期待楼主的下一次分享！”
页: [1]
查看完整版本: 运用Excel时把握了这4种IF函数用法，再亦不怕各样需要判断问题了