在使用excel表格中,我们常常要进行数据的统计,需要运用到计算公式。那么,excel表格如何添加计算公式呢?让我们一起来看一下吧。
![](https://iknow-pic.cdn.bcebos.com/cdbf6c81800a19d8f663e19621fa828ba71e46c4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
例如图片中求总分,要用到加法。单击总分单元格,输入“=”。
![](https://iknow-pic.cdn.bcebos.com/eac4b74543a9822652a14eb49882b9014b90ebc5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
选中1个需要运算的单元格【C2】,再输入“+”。再选中另一个需要运算的单元格【D2】,按Eenter完成。
![](https://iknow-pic.cdn.bcebos.com/eaf81a4c510fd9f93b7730fa372dd42a2934a4c5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
在运算中,很多时候要运用到减法。例如图片中,要求相差值。点击相差分下面的空白单元格,输入“=”。
![](https://iknow-pic.cdn.bcebos.com/95eef01f3a292df5d5a0c986ae315c6035a873c5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
选中需要运算的单元格【C2】,输入“-”。再选中另一个需要运算的单元格【D2】。
![](https://iknow-pic.cdn.bcebos.com/4b90f603738da9779c4ce3b8a251f8198718e3c6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
按Eenter键,完成减法运算。
![](https://iknow-pic.cdn.bcebos.com/d62a6059252dd42ad86a6438113b5bb5c8eab8c6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)