Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D worksheet question
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3D worksheet question
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) "Tabis" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Question | Excel Discussion (Misc queries) | |||
Worksheet question | Excel Discussion (Misc queries) | |||
end of worksheet question | Excel Worksheet Functions | |||
end of worksheet question | Excel Worksheet Functions | |||
end of worksheet question | Excel Worksheet Functions |