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.

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.

JessicaLee0137 wrote:

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

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

"JessicaLee0137" wrote:

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.

essicaLee0137

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

Mike Rogers

"Mike Rogers" wrote:

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

"JessicaLee0137" wrote:

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.

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.
--
David Biddulph


"JessicaLee0137" wrote in message
...
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.

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.

David Biddulph wrote:

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.
--
David Biddulph

"JessicaLee0137" wrote in message
...
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

Well spotted, Dave
--
David Biddulph

Dave Peterson wrote:
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.

David Biddulph wrote:

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.
--
David Biddulph

"JessicaLee0137" wrote in
message ...
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.