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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top