Excel怎么样运用乘法函数计算乘积?
<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>Excel表格时,<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>介绍一下<span style="color: black;">详细</span><span style="color: black;">运用</span><span style="color: black;">办法</span>。<a style="color: black;">#excel#</a></span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/5734072882f245cd9acf43786f1f3d6b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=xHXCMQID0IwnV165joEqlMY8Oxg%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">封面</p>
</div>
<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 style="color: black;">办法</span><span style="color: black;">过程</span></span></strong></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 style="color: black;">办法</span>一:用“*”号相乘</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;">1、打开Excel表格,在需要计算乘积的单元格输入公式:</span><strong style="color: blue;"><span style="color: black;">=C2*D2</span></strong><span style="color: black;">,输入完成按【enter】键,<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;"><strong style="color: blue;"><span style="color: black;">注:【=C2*D2】<span style="color: black;">暗示</span>需要相乘的数值单元格,直接用“*”号相乘<span style="color: black;">就可</span>。</span></strong></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/3000efffff5143bd9750a88521729335~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=7SFDS%2BjSzDXAcFknPaW0Q4Fae3w%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图2</p>
</div>
<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;">2、将鼠标移动到输入乘法算式的单元格右下角,当光标变成黑色+号时</span></strong><span style="color: black;">,</span><strong style="color: blue;"><span style="color: black;">双击鼠标左键向下填充</span></strong><span style="color: black;">,<span style="color: black;">就可</span>得到表格中每一组数据的乘积。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/9994dce41ec344f8bcef1a7d39de734d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=lJYnIPRIzZCPlfh7FLe%2FfrBr2gQ%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图2</p>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/f3103fc12d8b4a9db7a33f1af7eac33c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=bW%2BL9AW0z%2FT115mgRxvMi1SlChY%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图3</p>
</div>
<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 style="color: black;">办法</span>二:PRODUCT函数</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;">1、在Excel表格中需要计算乘积的单元格输入函数:</span><strong style="color: blue;">=PRODUCT(C2,D2)</strong>,输入完成按【enter】键,<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;">注:PRODUCT函数是</span>用于计算给出的数字的乘积的函数,<span style="color: black;">C2和D2<span style="color: black;">暗示</span>需要计算乘积的单元格,有多少就输入多少,中间用,号隔开<span style="color: black;">就可</span>。</span></strong></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/8fe3082c947444528b77f261be576397~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=Y2hOb%2Fwaxq3Ca2BBihA%2BG5M3hpo%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图4</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">2、将鼠标移动到输入函数的单元格右下角,</span><strong style="color: blue;"><span style="color: black;">当光标变成黑色+号时,双击鼠标左键向下填充公式</span></strong><span style="color: black;">,<span style="color: black;">这般</span>每一行的乘积都计算出来了。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/20c16bd7103a4369ae9f249f7e1e211a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=ZuWIdXqwT7pQhRVcZl9ab0dCC40%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图5</p>
</div>
<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 style="color: black;">办法</span>三:SUMPRODUCT函数</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;">1、在Excel需要计算乘积的单元格输入:</span><strong style="color: blue;"><span style="color: black;">=SUMPRODUCT(C2,D2)</span></strong><span style="color: black;">,输入完成按【enter】键,就<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;"><strong style="color: blue;"><span style="color: black;">注:</span><span style="color: black;">C2和D2指需要计算乘积的数值所在的单元格。</span></strong></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/0887e4b9ee5e4b419fd3f42f29e12548~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=6d9Qezza7T9kIqxj6x7FN4qCljw%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图6</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">2、将鼠标移动到<span style="color: black;">已然</span>输入公式的单元格右下角,</span><strong style="color: blue;"><span style="color: black;">当光标变成黑色+号时,双击鼠标左键向下填充函数</span></strong><span style="color: black;">,就<span style="color: black;">能够</span>快速得到所有乘积了。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/b5d5698aa43542a5ada8ecc897b34961~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=Ox5LsuCyqkecyNy%2F7rTKFttbmQI%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图7</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">3、</span><strong style="color: blue;"><span style="color: black;">SUMPRODUCT函数既<span style="color: black;">能够</span>计算单个的乘积,<span style="color: black;">亦</span><span style="color: black;">能够</span>计算乘积之和</span>。</strong>例如计算表格中所有乘积之和,在单元格输入公式:<strong style="color: blue;"><span style="color: black;">=SUMPRODUCT(C2:C7,D2:D7)</span></strong>,输入完成后按【enter】键,<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></strong><span style="color: black;">【</span><strong style="color: blue;"><span style="color: black;">C2:C7</span></strong>】<strong style="color: blue;"><span style="color: black;">和【D2:D7】分别<span style="color: black;">暗示</span>需要相乘的两组数据。</span></strong></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/92e4cb64f96140b89e9d3d27e54e4a05~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=AOhW0mWXo1aeHAjHgkVBs8wifm8%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图8</p>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/3675f37e5bd34cc5995ddb9a9e9a4adc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981997&x-signature=X5Dool7kAC2bfUW%2B9IBGoiHWjeg%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图9</p>
</div>
页:
[1]