excel函数教程 正确运用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>excel函数让工作更简单</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;">excel</span><span style="color: black;">最先接触的一个函数。估计<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><span style="color: black;">sum</span><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;"><strong style="color: blue;"><span style="color: black;">excel</span></strong><strong style="color: blue;"><span style="color: black;">函数教程——Excel函数教程：这个函数<span style="color: black;">处理</span>了我80%的工作问题</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">SUM</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 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><span style="color: black;">0</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;">SUM</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;">SUM</span><span style="color: black;">（</span><span style="color: black;">a,b,c,...</span><span style="color: black;">）或</span><span style="color: black;">SUM</span><span style="color: black;">（</span><span style="color: black;">rang</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;">a,b,c,...</span><span style="color: black;">中的各个字母<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;"><span style="color: black;">rang</span><span style="color: black;"><span style="color: black;">暗示</span></span><span style="color: black;">Excel</span><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 style="color: black;">第1</span>种：对数字求和</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><span style="color: black;">1</span><span style="color: black;">，</span><span style="color: black;">23</span><span style="color: black;">，</span><span style="color: black;">4</span><span style="color: black;">，</span><span style="color: black;">567</span><span style="color: black;">，</span><span style="color: black;">890</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=sum</span><span style="color: black;">（</span><span style="color: black;">1</span><span style="color: black;">，</span><span style="color: black;">23</span><span style="color: black;">，</span><span style="color: black;">4</span><span style="color: black;">，</span><span style="color: black;">567</span><span style="color: black;">，</span><span style="color: black;">890</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></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><span style="color: black;">1+23+4+567+890</span><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>
<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><span style="color: black;">1</span><span style="color: black;">，</span><span style="color: black;">23</span><span style="color: black;">，</span><span style="color: black;">4</span><span style="color: black;">，</span><span style="color: black;">567</span><span style="color: black;">，</span><span style="color: black;">890</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 style="color: black;">区别</span>单元格中输入：</span><span style="color: black;">1</span><span style="color: black;">，</span><span style="color: black;">23</span><span style="color: black;">，</span><span style="color: black;">4</span><span style="color: black;">，</span><span style="color: black;">567</span><span style="color: black;">，</span><span style="color: black;">890</span><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><span style="color: black;">A2</span><span style="color: black;">，</span><span style="color: black;">C4</span><span style="color: black;">，</span><span style="color: black;">B3</span><span style="color: black;">，</span><span style="color: black;">B4</span><span style="color: black;">，</span><span style="color: black;">D2</span><span style="color: black;">中分别输入<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;"><span style="color: black;">=sum</span><span style="color: black;">（</span><span style="color: black;">A2</span><span style="color: black;">，</span><span style="color: black;">C4</span><span style="color: black;">，</span><span style="color: black;">B3</span><span style="color: black;">，</span><span style="color: black;">B4</span><span style="color: black;">，</span><span style="color: black;">D2</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></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><span style="color: black;">A2</span><span style="color: black;">，</span><span style="color: black;">C4</span><span style="color: black;">，</span><span style="color: black;">B3</span><span style="color: black;">，</span><span style="color: black;">B4</span><span style="color: black;">，</span><span style="color: black;">D2</span><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 style="color: black;">能够</span>先把鼠标放到括号中，直接选其他单元格，<span style="color: black;">这般</span>就<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;"><span style="color: black;">按住</span><span style="color: black;">Ctrl</span><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;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/fHLuoBwokROoenWNRNYlBBk2UYhLAY4w5mcSfz1PLjOr7ibbpOgOe7IWXB3U3OX7BVoPH2PrTLC1rPicTthiatG1g/640?wx_fmt=gif&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></span></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;">VLOOKUP</span></strong><strong style="color: blue;"><span style="color: black;"><span style="color: black;">查询</span><span style="color: black;">显现</span>错误值的问题</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1</span><span style="color: black;">、<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;"><span style="color: black;">XCEL</span><span style="color: black;">在</span><span style="color: black;">VLOOKUP</span><span style="color: black;"><span style="color: black;">查询</span>不到，就</span><span style="color: black;">#N/A</span><span style="color: black;">的错误值，<span style="color: black;">咱们</span><span style="color: black;">能够</span>利用错误处理函数把错误值转换成</span><span style="color: black;">0</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;">=IF(ISERROR(VLOOKUP</span><span style="color: black;">（参数略）</span><span style="color: black;">),"",VLOOKUP</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;">EXCEL</span><span style="color: black;">，</span><span style="color: black;">EXCEL</span><span style="color: black;">中<span style="color: black;">供给</span>了一个新函数</span><span style="color: black;">IFERROR</span><span style="color: black;">，处理起来比</span><span style="color: black;">EXCEL</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;">IFERROR</span><span style="color: black;">（</span><span style="color: black;">VLOOKUP</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;">2</span><span style="color: black;">、</span><span style="color: black;">VLOOKUP</span><span style="color: black;">函数<span style="color: black;">查询</span>时<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;"><span style="color: black;">A</span><span style="color: black;">、实在是<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;"><span style="color: black;">B</span><span style="color: black;">、<span style="color: black;">查询</span>的字符串或被<span style="color: black;">查询</span>的字符中含有空格或看不见的空字符，验证<span style="color: black;">办法</span>是用</span><span style="color: black;">=</span><span style="color: black;">号对比一下，<span style="color: black;">倘若</span>结果是</span><span style="color: black;">FALSE</span><span style="color: black;">，就<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;"><span style="color: black;">C</span><span style="color: black;">、参数设置错误。</span><span style="color: black;">VLOOKUP</span><span style="color: black;">的最后一个参数<span style="color: black;">无</span>设置成</span><span style="color: black;">1</span><span style="color: black;"><span style="color: black;">或</span>是<span style="color: black;">无</span>设置掉。第二个参数数据源区域，<span style="color: black;">查询</span>的值不是区域的<span style="color: black;">第1</span>列，<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;">D</span><span style="color: black;">、数值格式<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>是把<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;"><span style="color: black;">文本转换成数值：</span><span style="color: black;">*1</span><span style="color: black;">或</span><span style="color: black;">--</span><span style="color: black;">或</span><span style="color: black;">/1</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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">VLOOKUP</span><span style="color: black;">是一个<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><span style="color: black;">VLOOKUP</span><span style="color: black;">函数是</span><span style="color: black;">Excel</span><span style="color: black;">中几个最重函数之一，<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> </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&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/UpMchEYYgCpZqufeeibRs0aZtPQdPr9fVyqC4DicnNE6aO4s5mHwefQia9icJ2Y9ic8j7LPuUmVDf6LZiaAVriaBHmx5Q/640?wx_fmt=png&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/UpMchEYYgCpZqufeeibRs0aZtPQdPr9fVyqC4DicnNE6aO4s5mHwefQia9icJ2Y9ic8j7LPuUmVDf6LZiaAVriaBHmx5Q/640?wx_fmt=png&wxfrom=5&wx_lazy=1&wx_co=1&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&wxfrom=5&wx_lazy=1&wx_co=1&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&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&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&tp=webp&wxfrom=5&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&wxfrom=5&wx_lazy=1&wx_co=1&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&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/I93RVnDMNRHlVHxswCwfcPfKKLJMlREDRGtuPYiaahXoeuank9OTicAj071iaZx5H5jOzacBK16Fk67qxp7svNVTg/640?wx_fmt=jpeg&wxfrom=5&wx_lazy=1&wx_co=1&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 》</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>
楼主听话，多发外链好处多，快到碗里来！外链论坛 http://www.fok120.com/ 楼主的文章深得我心，表示由衷的感谢！ 我深受你的启发，你的话语是我前进的动力。
页:
[1]