# Thread: Excel Basic Formulas

1. What are the Formulas of adding , Subtracting if I want to Apply in Excel?  2.

3. 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.  4. 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  5. 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....  6. One of the easiest method using formulae that will minimize the consumption of time to do addition and subtraction..  7. 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.  8. I am looking for this thanks.  Bookmarks
 Posting Permissions
 You may not post new threads You may not post replies You may not post attachments You may not edit your posts   BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are On Terms of Use Agreement