I need help working with excel. How do I make formulas for the cells for adding and subtracting?

Question

what i want to do is - make formulas to add different cells together or subtract

Answer 1

double click on the cell you want the formula to be in. (or you can press F2 when you selected the cell). type "=" followed by your cell location. then "+" to add. "-" to subtract. and cell location again.. etc...

Example: =B2+C3+D4+F5-C4-D5

Answer 2

Instructions

* STEP 1: Start Microsoft Excel and open the file you want to change.
* STEP 2: Double-click on the cell where you want the total to appear.
* STEP 3: Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell.
* STEP 4: Enter the formula, then press Enter. Follow the steps below for an example.
* STEP 5: Enter an opening parenthesis character: (.
* STEP 6: Enter a cell name. For example: =(E2.
* STEP 7: Press the + key.
* STEP 8: Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3).

Then for minus step 8 would look like =(e2-e3) obviously place the cells that you want to add or subtract instead of the e2 and e3 etc.

Hope this helps

Rezz

Answer 3

You can click on the square you want the formula to affect then there is a bar behind fx type your formula related to cells or whatever you want. For example type a3=a1+a2.
Another way is for example a want a3=a1-a2
click on a3 press = click on cell a1 Press key - then click on cell a2 and hit enter
notice it plugs the formula in for you.

for more formula help, click help in excell and search formula's

It really is easy.

Answer 4

type this for addition: =cell range+cell range
type this for subtraction: =cell range-cell range

Where I have the "cell range", insert your own numbers or cell ranges. You can also use the "autosum" button on the Standard Toolbar, then highlight the range of cells you want to add.

If you have Office 2003, you can click on help and find a tutorial.

Answer 5

You need to be more specific. I use Excel alot, and I can certainly help. Click the email link on my profile, and tell me exactly what you want to do. I can help