Things You'll Need:
- Excel Book
- Microsoft Excel
-
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).
-
Step 9
Enter a minus sign and a third cell name. For example: =(E2+E3)-E4.
-
Step 10
Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell.









Comments
darthvaughn said
on 8/6/2009 how do i subtract form one cell the delete the value from the cell it was subtracted from(HUH?)
theharv said
on 6/4/2009 I'd like to know how to create a formula that shows the result of a SUM, if it is greater than, say 100, the result is displayed in bold red. (or any color)?
tedmag said
on 12/11/2008 I know I can instruct EXcel to add three numbers together in a row, for instance e+f+g-i=j. Right now I am doing it line by line, but what i'd like to do is instruct excel to do the same formula for every line in a column of 15 rows. Thank you!
jlow said
on 10/9/2008 nm
jlow said
on 10/9/2008 I was wondering (probably a dumb question) but can i take cell a2 on tab 1 then subtract it by cell a2 on tab 2 and then out put the sum on a2 in tab three? I know how to do sums of cells i'm just not sure how to make use the different tabs like that.