Excel Basic Formulas

• November 28th, 2017, 12:33 PM
maryamnawaz1000
Excel Basic Formulas
What are the Formulas of adding , Subtracting if I want to Apply in Excel?
• November 28th, 2017, 01:26 PM
PhDemon
If you are simply adding two cells together you can just use the + symbol between the cell locations. If there are a lot you can use the SUM function e.g. SUM(A1:A8) will add together all of the numbers in the cells between A1 and A8. For subtraction use the - sign. As there is no subtract function in Excel a work around is to put a - sign in front of the numbers in the cells and use the SUM command.
• November 28th, 2017, 01:36 PM
perdurat
cell A1:number,cell B1:number, C1:result
select C1, type =, select A1, type +, select B1, click enter

cells A1:A10 numbers, cells B1:B10 numbers, C1:C10 results
apply 1st method for C1
select C1, click ctrl and c, click&drag C2:C10, click ctrl and v

cell A1 number, cells B1:B10 numbers, C1:C10 results
apply 1st method for C1
modify the description in formula editor (above worksheet,textbox on rightside of Fx) change C1 by \$C\$1

cells A1:A10 numbers, A11 result
click A11, type sum( ,click & drag A1:A10, type ), click enter
• March 2nd, 2018, 12:30 AM
Patricia Riffle
Add the values in a column or row by using a button. You can use AutoSum to quickly sum a range of numbers in a column or row. Click an empty cell below a column of numbers or to the right of a row of numbers, and then click AutoSum. Excel selects what it determines to be the most likely range of data....
• March 7th, 2018, 12:02 AM
Patricia Riffle
One of the easiest method using formulae that will minimize the consumption of time to do addition and subtraction..
• March 7th, 2018, 04:23 AM
tk421
Quote:

Originally Posted by Patricia Riffle
One of the easiest method using formulae that will minimize the consumption of time to do addition and subtraction..

You might wish to take note of the fact that the OP asked this question a half-year ago or so and that she was also banned.
• October 17th, 2018, 03:36 AM
mikeedison
I am looking for this thanks.