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