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

Similar Threads

Update cell value based on name and specific date 1
add hyperlink using sheet names and cells(i,j) 3
Vlookup and return sheet name also 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Automatic Sumning of Same Cell from Different Sheets 3
Excel Is this possible?? 3
Excel VBA to move cells to sheet2 based on selection in sheet1 0
copying only selected data from Sheet 1 to Sheet 2 2

Back
Top