Excel Formula - Between Worksheets

[Craig Lescombe]

Hello All - I am new to Excel, and am used to working on only
worksheet. I would greatly appreciate if someone could provide me wit
the formula for the following. I have a new book with 3 worksheets.
need to pick a figure from worksheet 1 - entitled "INCOME", cel
address P5, and from this, subtract a figure from worksheet 2 -
entitled "EXPENSE", cell address Q5, to have the result appear i
worksheet 3 - entitled "BANK", cell address F11

 

[Paul]

Hello All - I am new to Excel, and am used to working on only 1
worksheet. I would greatly appreciate if someone could provide me with
the formula for the following. I have a new book with 3 worksheets. I
need to pick a figure from worksheet 1 - entitled "INCOME", cell
address P5, and from this, subtract a figure from worksheet 2 -
entitled "EXPENSE", cell address Q5, to have the result appear in
worksheet 3 - entitled "BANK", cell address F11.

When working within a single workbook, are you familiar with the technique
of navigating to a cell instead of typing in its reference?

For example, if I want to enter the formula
=A1
I can either type that in, or I can type the "=" and then select cell A1 and
press Enter.

Similarly, if I want to enter the formula
=Sheet2!A1
I can either type that in, or I can type the "=" and then switch to Sheet2,
select cell A1, and press Enter.

If you are not familiar with this, try it, entering cell and range
references by navigating, and entering more than one reference in a formula,
etc., until you are comfortable with the method.

Entering a reference from another workbook is simply an extension of this.
Open both workbooks together. You can switch between them using the Window
menu - either by clicking on the workbook name to bring it to the front, or
by displaying both workbooks (side by side or one above the other). Start
entering the formula by typing "=" and when you need the external reference,
get it by navigating to the other workbook.

 

[BrianB]

In F11
=income!P5-expense!Q5

You can do this by typing or ............
select F11, type =, select P5, type -, select Q5, Enter