3D worksheet question

T

Tabis

I have 3 sheets with sheet 1 as budget, sheet 2 as actual sales and I keep
getting an error with my formula to get the variance for sheet 3. I'm using
=Sheet1!:Sheet2!C12 and it adds not subtracts, what am I doing wrong? Thanks
for any help.
 
C

cm

you must have a subtraction sign between the cell references:

=Sheet1!C12 - Sheet2!c12 (if you are subtracting c12 in sheet 2 from c12 in
sheet 1)
 

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

How to subtract with 3D between 3 worksheets 2
EXCEL - IF(IFERROR(VLOOKUP question 0
Return Value from a Range (depends on input to determind month) 2
Pivot table help. 2
Splitting data from one spreadsheet into multiple spreadsheets 2
Is it possible to offset a worksheet reference? 5
Automatic Sumning of Same Cell from Different Sheets 3
First column of range in VLOOKUP contains formula 2

Top