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

D

Dave R.

Your sentence is a bit confusing (subtract.. then minus), but try

=Sheet2!B6-Sheet1!B12
 
B

Bob Phillips

=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

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.
 

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

Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Need Help with a VBA subroutine 0
add hyperlink using sheet names and cells(i,j) 3
Averaging a column that contains text 4
FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM 3
Payment calculation 1
Table cross-check 0
RELATIVE REFERENCE WHEN MATCHING 2 PRODUCTS 4

Top