esc0rp 发表于 2024-10-1 14:38:20

常用的excel函数公式大全的运用办法


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">常用的excel函数公式大全的<span style="color: black;">运用</span><span style="color: black;">办法</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Microsoft Excel是<span style="color: black;">机构</span>的办公软件Microsoft office的组件之一，Excel <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>excel常用函数有<span style="color: black;">那些</span>呢?今天，<span style="color: black;">博主</span>就教<span style="color: black;">大众</span>在Excel中进行常用函数部分的操作<span style="color: black;">办法</span>。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　Excel中常用函数部分的<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;">　　IF函数</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　把公式产生的错误值<span style="color: black;">表示</span>为空</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　公式：C2</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　=IFERROR(A2/B2,"")</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>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　IF多<span style="color: black;">要求</span>判断返回值</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　公式：C2</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　=IF(AND(A2&lt;500,B2="未到期"),"补款","")</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>成立用AND,任一个成立用OR函数。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　COUNTIF函数(统计重复的人数)</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　公式:B2</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　=COUNTIF(Sheet15!A:A,A2)</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　说明：<span style="color: black;">倘若</span>返回值大于0说明在另一个表中存在，0则不存在。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　SUMPRODUCT函数(统计不重复的总人数)</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　公式：C2</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">=SUMPRODUCT(1/COUNTIF(A2:A8,A2:A8))</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　说明:用COUNTIF统计出每人的<span style="color: black;">显现</span>次数，用1除的方式把<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;">　　SUMIF函数(隔列求和)</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　公式：H3</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　=SUMIF(A2:G2,H2,A3:G3)</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　或 =SUMPRODUCT((MOD(COLUMN(B3:G3),2)=0)*B3:G3)</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>规则用第2个公式。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　SUMIF函数(单<span style="color: black;">要求</span>求和)</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　公式：F2</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　=SUMIF(A:A,E2,C:C)</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　说明：SUMIF函数的基本用法。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">倘若</span>想要系统学习Excel,<span style="color: black;">或</span>直接套用模板，<span style="color: black;">能够</span><span style="color: black;">瞧瞧</span>点击下方链接或<span style="color: black;">照片</span>查看:</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/UpMchEYYgCpZqufeeibRs0aZtPQdPr9fVyqC4DicnNE6aO4s5mHwefQia9icJ2Y9ic8j7LPuUmVDf6LZiaAVriaBHmx5Q/640?wx_fmt=png&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1&amp;tp=webp" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/UpMchEYYgCpZqufeeibRs0aZtPQdPr9fVyqC4DicnNE6aO4s5mHwefQia9icJ2Y9ic8j7LPuUmVDf6LZiaAVriaBHmx5Q/640?wx_fmt=png&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1&amp;tp=webp" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/UpMchEYYgCpZqufeeibRs0aZtPQdPr9fVyqC4DicnNE6aO4s5mHwefQia9icJ2Y9ic8j7LPuUmVDf6LZiaAVriaBHmx5Q/640?wx_fmt=png&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1&amp;tp=webp" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><strong style="color: blue;"><span style="color: black;">Excel模板表格图表模板4000套、甘特图580套、工作计划255套！（另函数零<span style="color: black;">基本</span>入门视频透视表VBA课程）</span></strong></a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/fHLuoBwokRNiaTiclxf9ZiaKOsEtiaQptVqojMXSNxFPjb7IehAnxAmJJCRFiaB7IKBmu9rpmXoznic1yqk34ZpjibP2Q/640?wx_fmt=jpeg&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1&amp;tp=webp" style="width: 50%; margin-bottom: 20px;"></span></a></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/fHLuoBwokRPo79YsfLjOwp422cMIvV7RsOEiaQOcehcfCn8Q4CZv61ewcghNTf7CmGFNssqALN4T4YCOBwdVwzA/640?wx_fmt=jpeg&amp;from=appmsg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/fHLuoBwokRPfIVInIqEr2Qnic0T6rmLcTpqJlKlO00x4bUrNV2LeqbuV1QPu5bVmbqSHkRaHvyxqMR1jLKBlsbw/640?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Excel秘籍大全</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/7QRTvkK2qC6hzicPF91rs9ItM18PtNACZP7sUrVePibyGR92ibmnNkSIkT0M5DWddcBmOCSoRyWiciaYIwMhtS0sY1g/640?wx_fmt=png&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1&amp;tp=webp" style="width: 50%; margin-bottom: 20px;">点个“赞+分享”，鼓励鼓励我吧！<span style="color: black;">以下<strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">《900套高逼格工作模板.xls 》免费下载，不收一分钱！</strong></span></strong></span><span style="color: black;">常用Excel</span><span style="color: black;">用Excel玩好报表</span><span style="color: black;">是必不可缺的技能</span><span style="color: black;">要<span style="color: black;">晓得</span>一张好的图表</span><span style="color: black;"><span style="color: black;">能够</span>做到一图胜千言！</span><img src="https://mmbiz.qpic.cn/mmbiz_png/ITklNlO9RDGkLTMIhZMibFaibmxgj6JDicoIG2DKodYZhjaWicqiat5gJDDx77rzkz8f5TPfCcyljeibO8dEQDgpYkFA/640?wx_fmt=png&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1&amp;tp=webp" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/I93RVnDMNRHlVHxswCwfcPfKKLJMlREDRGtuPYiaahXoeuank9OTicAj071iaZx5H5jOzacBK16Fk67qxp7svNVTg/640?wx_fmt=jpeg&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1&amp;tp=webp" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">今天<span style="color: black;">举荐</span>的<span style="color: black;">超实用干货</span></span></strong><strong style="color: blue;"><span style="color: black;">是</span></strong><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">《900套高逼格工作模板.xls&nbsp;》</strong></span></strong></span><strong style="color: blue;"><span style="color: black;">3.2G</span></strong><strong style="color: blue;"><span style="color: black;">高逼格Excel可视化模板</span></strong><strong style="color: blue;"><span style="color: black;">制作精美 可直接套用</span></strong><strong style="color: blue;"><span style="color: black;">适合自用和内部培训<span style="color: black;">运用</span></span></strong>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">领取方式</p>

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关注公众号</p>

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">私信发送关键字：<strong style="color: blue;"><span style="color: black;">900</span></strong></span></p>
    <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>免费领取</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">资料<span style="color: black;">源自</span>于网络，公益分享，如有侵权，联系删除</p>




j8typz 发表于 2024-10-2 15:39:51

太棒了、厉害、为你打call、点赞、非常精彩等。

wrjc1hod 发表于 2024-11-3 08:55:35

你的话语如春风拂面，让我心生暖意。
页: [1]
查看完整版本: 常用的excel函数公式大全的运用办法