Excel中的减法公式一般表述为【=A1-B1】或者是【SUM(A1-B1)】
操作步骤如下:
1、如图,A1列要和B1列做减法计算。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/50da81cb39dbb6fd257b87810424ab18972b3770?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中C1,输入【=A2-A1】,然后回车,C1单元格此时已经显示相减的结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a50f4bfbfbedab6493772f67fa36afc379311e0b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、第二种做法就是选中C1,然后单击【插入函数】按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6a63f6246b600c33621cbc6f174c510fd9f9a134?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、插入函数后在弹出的窗口中选择常用函数【SUM】,然后点击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9198618367adab4e0a879e486d4b31c8701e419?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、选定函数后会弹出对话框让你选择具体的参数,在第一栏中输入【A1-B1】然后点击确定,C1单元格中就会自动计算出相减结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d043ad4bd11373f0081f0d38a90f4bfbfbed0470?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、如果C1列整列都是同样的计算方式的话选中C1单元格,然后把鼠标移动到单元格右下角按住鼠标左键不放然后下拉就可以复制计算公式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b64543a98226cffc8252dd15b4014a90f603ea19?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)