difference of 2 cells from 2 sheets to appear on sheet 3?

[wzkm123]

I am trying to find the difference between a cell on sheet 1 and a cell on
sheet 2. I want the answer to appear on sheet 3. However, when I enter =
and then click on the cell on sheet one, use the minus sign, then click on
the cell in sheet two, it does not calculate.

HELP!

 

[Eduardo]

Hi,
It looks like the calculation is set up as manual, if you press F9 it will
calculate. go to excel options, formulas and set the calculation to automatic

 

[trip_to_tokyo]

In EXCEL 2007 I have:-

1. Sheet1 cell J 10 the number 10.

2. Sheet2 cell J 10 the number 25.

3. Sheet3 cell J 10 the formula:-

=Sheet2!J10-Sheet1!J10

The above returns the number 15.

Hope the above helps.

If it does please hit Yes.

Thanks.