If A2, A3 and A4 are subtracted from the value of cell A 1, the formula can be written in cell A5.
=A 1-A2-A3-A4
This formula can first calculate the SUM of A2, A3 and A4 with SUM function, and then subtract this sum with A 1 to write the formula.
= a 1- and (A2:A4)
subtraction
=SUM(A 1:A5)-B6
=A 1+A2+A3+A4+A5-B6
A 1 to A5 plus or minus B6 is 9.
Excel subtraction formula
It is a formula for subtraction calculation in excel, which is generally expressed as "=A2-A 1" or "=SUM(A2-A 1)".
If A 1 is 5 and A2 is 8, there are two ways to write the formula of subtracting A 1 from A2. One can be written as "= a2-a1"; Two can be written as "=SUM(A2-A 1)". These two methods are generally acceptable, but in the case of continuous application of formulas, there will be errors in the methods for a period of time, so it is no problem to replace them with formula 2.
Refer to the above content: Baidu Encyclopedia -excel subtraction formula