Your sentence is a bit confusing (subtract.. then minus), but try =Sheet2!B6-Sheet1!B12
D Dave R. Jun 3, 2004 #1 Your sentence is a bit confusing (subtract.. then minus), but try =Sheet2!B6-Sheet1!B12
B Bob Phillips Jun 3, 2004 #2 =Sheet1!B12-Sheet2!B6 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
=Sheet1!B12-Sheet2!B6 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
J JE McGimpsey Jun 3, 2004 #3 One way: =Sheet2!B6 - Sheet1!B12 You can do this easily by entering "=" (without the quotes) in your target cell, navigating to Sheet2, cell B6 and clicking in it, typing "-" and navigating to Sheet2!B12 and clicking, then hitting Enter. XL will supply the sheet references.
One way: =Sheet2!B6 - Sheet1!B12 You can do this easily by entering "=" (without the quotes) in your target cell, navigating to Sheet2, cell B6 and clicking in it, typing "-" and navigating to Sheet2!B12 and clicking, then hitting Enter. XL will supply the sheet references.
