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

  • Thread starter Thread starter wzkm123
  • Start date Start date
W

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!
 
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
 
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.
 
Back
Top