Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference of 2 cells from 2 sheets to appear on sheet 3?
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference of 2 cells from 2 sheets to appear on sheet 3?
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 "wzkm123" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
difference of 2 cells from 2 sheets to appear on sheet 3?
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. "wzkm123" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a 3rd sheet containing cells in both Sheets 1 and 2 | New Users to Excel | |||
Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
copying text on sheet 1 to corresponding cells on sheets 2 to 5 | New Users to Excel | |||
Graph on each sheet when I mark same cells on multiple sheets | Excel Discussion (Misc queries) | |||
sum difference cells on multiple sheets | Excel Worksheet Functions |