How do I create formulas between worksheets?

[JessicaLee0137]

What I am looking to do is this. I have a dollar figure in a cell on one
sheet. On another sheet I have another dollar figure. I would like to
subtract the dollar figure on Sheet 1 from the dollar figure on Sheet 2. I
will have to do this a lot so the cells will be different each time but I
don't know where to start. Also, I have renamed the worksheets so when doing
the formula will I use the new names in the formula? Or still refer to them
as "Sheet 1" and "Sheet 2"? I hope this makes sense. Thank you.

 

[Dave Peterson]

You can start your formula by typing an = sign.

Then use the mouse to point at the cell that contains the first value, then type
the minus sign, then use the mouse to point at the cell that contains the second
value.

(You'll have to select the worksheet before you select the cell.)

And you'll see the syntax for the formula.

Then try changing the name of the sheet and watch excel adjust the formula for
you.

 

[Mike Rogers]

essicaLee0137

The easiest way to do this is to let excel set it up for you. Lets assume
your result will be in A15 of sheet 1. In A15 start by putting an equal sign
in "=" (no quotes) then goto sheet 2 and select select the cell you want to
subtract from, then goto sheet 1 and select the cell you want to sutract. tap
the enter button and you should have your desired resilts in A15, (Format A15
the same as your one of your other cells.)

Mike Rogers

 

[Mike Rogers]

essicaLee0137

I did miss a minus sign after you select the first cell. Sorry hope you got
it.

Mike Rogers

 

[David Biddulph]

The formula should look something like
='second sheet name'!A1-'first sheet name'B2

You can omit the single quotes of there are no spaces in the sheet name but
they do no harm.

The easiest way to create your formula is to type the = sign in the celll
where you want the result, then go to sheet 2 and click in your first cell,
then type the - sign, then go to sheet 1 and click in the second cell, then
accept the formula.

 

[Dave Peterson]

Typo alert.

='second sheet name'!A1-'first sheet name'B2
should be:
='second sheet name'!A1-'first sheet name'!B2

(added another exclamation point)

And to the OP:

Just to add--don't include the sheet name for the cells on the same sheet as the
formula.