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

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!
 
E

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
 
T

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.
 

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

Top