Help me I want to know how to carry subtraction on excel 2003 and please dont mock me i just cant fgure it out

Answer 1

if you have
cell1
- cell2
and the answer in cell threee just set any cell to reference cell3 as
= cell 3 (whatever formaul = new answer
Subtraction
= 8 - 3= A3 - B1
Try looking here
http://www.usd.edu/trio/tut/excel/

Answer 2

Don't type sum. It will work, but it's the wrong way to do it, and will cause you trouble later. Just go into a cell and type:

= [number or cell reference, which you can get by clicking in the cell] - [number or cell reference]

So, for example,

=3-2
Cell will display 1

=A2 - A1
where cell A2 contains 5 and cell A1 contains 3, cell will display 2.

Answer 3

Type in a suitable formula.

For instance, if you want the value in cell B2 to be subtracted from the value in cell D2 and the result to be shown in cell E2, type in cell E2 the following formula:

+D2-B2

I always type in "+" at the start of a formula. It's just a habit carried over from years ago.

Likewise, if you want to add the values in those two cells, type in the following:

+D2+B2

Basically the whole thing follows the same logic. Think of the cells as separate entries, and where you want the entries to interact in formulas, all you have to do is type the cell address into the formula.

Also, when you copy the formula in one cell and paste it in a cell on a different row, the cell addresses change accordingly. For instance, if the formula you typed in cell E2 refers to cells B2 and D2, and you copied and pasted in cell E10, the references automatically change to B10 and D10. That way, the same formula can be applied to different values on different rows/clumns.

Once a formula gets a little bit complex, you may want to write it out on a piece of paper first just to get it right in your head. I find that that's easier to work on rather than staring blankly at the computer screen trying to figure out why things are not adding up.

Just think of x and y in your school maths class, and replace the x and y with the cell addresses.

Answer 4

I know excel well but what do you mean carry subtraction?Do you mean just subtraction. You have to format the cell to do this. Using the format cell option. If you go to the little lightbulb up in the toolbar and ask it how to format a cell to subtract it will give you the step by step instructions for this.

Answer 5

I would like to help.. but what do you mean by "carry subtraction"?

Is it you want to see a " - " in a cell? That will be " '- "

Or you wan to do a calculation, e.g. 100 - 10 = 90?
Click in a cell, then key =, then click on the number you wan, then key -, then click on the next number you wan. Then hit Enter.

Answer 6

in a celll type this...

=sum(b1-b2)

replace b1 and b2 with your cell numbers

(yes, i know it says sum, but the subtraction sign between them will subtract them will subtract it.)

Have a great day!

Answer 7

if you want a normal substraction then type =4-3 and then ENTER.. If you want to substract other cells in your excell page then do the following =(click on the cell you want.. it automatically appears)- (click on the other cell) and hit ENTER

Answer 8

in your 'answer' cell, use the formula =A1-A2
(A1 and A2 are obviously examples of the cells, replace this as appt)
The '=' sign tells it that you're typing in a sum.

Answer 9

Go into a cell... and type sum(a1 - a2)

or whatever your cell numbers are...

Answer 10

formula in the cell concerned:
=sum(cell number-cell number)