I need to subtract sheet 2 cell B6 minus sheet 1 B12, whats the formula

  • Thread starter Thread starter Guest
  • Start date Start date
Your sentence is a bit confusing (subtract.. then minus), but try

=Sheet2!B6-Sheet1!B12
 
=Sheet1!B12-Sheet2!B6


--
HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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.
 
Back
Top