Excel计算算式结果，3种办法，1分钟学会
<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;"><span style="color: black;">此刻</span>直接算出成交的价格是多少，<span style="color: black;">亦</span><span style="color: black;">便是</span>把B列的算式结果给计算出来</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/1df710377bde4313a37f450093c9c147~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=ud5Q1N8RmCjBcQsqOvmhNtVKF6Y%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">倘若</span>你用的是国产的WPS的话，就<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;">输入的公式是：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">=EVALUATE(B2)</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">EVALUATE这个公式，<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-6w9my0ksvp/1084383d68344a81a937c57852ad4c4f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=P8DaT%2FjMh02Q%2BPqSlgW3L2nVt4U%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>有的小伙伴用的是OFFICE的话，就<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;">下面有3种<span style="color: black;">处理</span><span style="color: black;">办法</span>：</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1、<span style="color: black;">运用</span><span style="color: black;">查询</span>替换法</h1>
<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;">="="&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>把B列单元格前面<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-6w9my0ksvp/e97989a197cd4c41add8c53ae1e1c0a2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=N3NKd%2FJ4%2F6MXsVEYIE08DMreOFI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>复制C列数据，再右键粘贴成数值格式，图标是123的这个，<span style="color: black;">这般</span><span style="color: black;">能够</span>去掉C列里面的公式：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d26aeab175574a27ad85974e8a97e790~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=Csv%2Byi1qWAGF%2BKPm6tbs%2BoCazkI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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><span style="color: black;">查询</span>替换，快捷键是CTRL+H</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/1be71c24afaf4e688ec8207620ae6a79~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=m%2B7WVLzqnl9XSmRpSjzWMocMMKQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7fb493d719e04d85964fee19a0cf4f24~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=1a4RmQsZEH1%2F2A8rKEngaZOICsI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">办法</span>2：<span style="color: black;">运用</span>数据分列法</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">前2个<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>选中C列，点击数据选项卡，<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-6w9my0ksvp/bd1d79a9fcd64b058757ad97bf92b772~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=M0Tjteh3VQziJGo0C5hYMdDiXJc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/fe8e08151f304cd6b6c099113f484946~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=NM76ckmHnd%2B63B1tXZJ1stcUhDQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">办法</span>3：<span style="color: black;">运用</span>宏表函数</h1>
<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><span style="color: black;">运用</span>EVALUATE，<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>光标需要放在C2单元格（这步很重复，<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c6eed9b7501642f197e1a10cc6a26a21~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=arnl4Jtp8ZEVvsZeoAKzitXHGDE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>自定义一个任意名<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;">=EVALUATE(B2)</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/885dd3188b4b4f46becdf575017684c9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=x4uSzcV4ubkFjfBaMUG5qc6c9w0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>回到单元格中，在C2中输入的公式是：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">=计算，向下填充，就得到了所有的结果</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b3ea589b7e804f6ca4feb40fd6953d63~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=UmCeLLWOb7rD4Q8Od7ofXAYVpbk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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需要另存为xlsm格式的文件，要<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-6w9my0ksvp/562614cde6984636813ed3030f0417ff~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727984295&x-signature=6aMAxtohBbpHNWZmtlYpWZN0Zbo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于这个小技巧，你学会了么？动手试试吧！</p>
软文发布论坛开幕式圆满成功。 http://www.fok120.com 你说得对，我们一起加油，未来可期。 回顾历史，我们不难发现：无数先辈用鲜血和生命铺就了中华民族复兴的康庄大道。
页:
[1]