Forum Discussion
Excel Subtraction
Good Afternoon, I have always used =sum(cell name-cell name) for subtracting to cells from each other. Now I am setting up the exact same worksheet in a workbook, just a different year and all I get...
There is no function to subtract values between... All you need is formula which starts with =
For example: you have 50 and 30 in cells A1 and B1 respectively.
All you need to do is, in cell C1, execute: =A1-B1 and press enter.
You will have 20 in cell C1.
The SUM function is used to add up numeric values in two or more range..
For example to add the values in cells A1 and B1 as described above.
Just deploy =SUM(A1:B1) and click Enter
You will have 80
For example: you have 50 and 30 in cells A1 and B1 respectively.
All you need to do is, in cell C1, execute: =A1-B1 and press enter.
You will have 20 in cell C1.
The SUM function is used to add up numeric values in two or more range..
For example to add the values in cells A1 and B1 as described above.
Just deploy =SUM(A1:B1) and click Enter
You will have 80