I need to subtract cell B-6 sheet2 from cell B12 sheet1/ Excel 2003

Q

QWERTY

I need to subtract cell B-6 sheet2 from cell B12 sheet1/ Excel 2003
thanks in advance
 
C

CLR

Put this formula in any cell EXCEPT the two that are part of the formula.

=Sheet1!B12-Sheet2!B6

Or, if Sheet1 cell B2 already has a formula in it and you want it reduced
by subtracting Sheet2 cell B6 from it, just add this to the end of your
existing formula.

(YourFormula)-Sheet2!B6

Vaya con Dios,
Chuck, CABGx3
 

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

Need Help with a VBA subroutine 0
Copy data automatically from sheet1 to sheet2 0
Populate growing range of cells from Sheet1 to Sheet2 10
Copy addition formula of non-consecutive horizontal cells 2
Automatically copying data from sheet1 to sheet2 2
Place picture in Excel cell 0
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
add hyperlink using sheet names and cells(i,j) 3

Top