The advantage of doing this is that the numbers in cells A1 and A2 can change and the value in A3 will automatically calculate the new equation. The number 3 appears in cell A3 because 7-4=3.
:max_bytes(150000):strip_icc()/001_3124091-5ba3f47446e0fb00505f6a68.jpg "how to insert formula in excel to subtract numbers")
Subtract 7- 4 in another cell using the cell references for A1 and A2.Īnswer: In cell A3 type “=A1-A2” (without the quotation marks) The number 7 is in A1 and the number 4 is in A2. You can subtract the values in different cells by referencing them just as you do with addition or any other mathematical operation.
Referencing Cells and using the hyphen symbol for subtraction You are telling Excel that you want the cell you have clicked on to be equal to the equation after the equal sign.
0 kommentar(er)
