Link to home
Start Free TrialLog in
Avatar of mikecox_
mikecox_Flag for United States of America

asked on

Why am I getting the wrong value

am trying to bring values from the Master worksheet into the Budget worksheet.  I'm sure I have the  right formula but the resulting value is wrong.  What am I doing wrong.

 User generated image
Also, I recently put a formula in a cell but the formula displayed, not the value. How do I make the value display?
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Is it possible that Calculation is set to manual?  

Press [F9] and see if the value changes.  If so - and it's correct - set the calculation mode to Automatic.
Menu: File - Options - Formulas (on left) - Workbook Calculation section - "Automatic" checkbox.

If not, we'll probably need to see an example workbook.

Regards,
-Glenn
Another possibility:  Are these two different workbooks?  The title bars on the two windows show different names:
* "Master Budget 2012-2013"
* "Master Budget"
What is the formula in the Budget worksheet in cell B7?

What is the formula which is displaying as a formula instead of a value?  If that cell's data type set to Text or General?  It should be set to General.

What version of Excel are you using?
@WalkaboutTigger:  The formula is Master!T16.  However, it is not clear that this the same workbook.

Additionally, the formula in "Master Budget" cell B7 is in a section titled "2013-2014", yet the value highlighted in the other workbook (2,137) is in a workbook titled "Master Budget 2012-2013".
On the left, we see the file name "Master Budget 2012-2013" above cell A15...

On the right, we see the file name "Master Budget" above cell A2...

Copy cell T16 in the file Master Budget 2012-2013 and paste to cell B7 in file Master Budget!

Now you should see ='[Master Budget 2012-201]Master'!$T$16 rather than =Master$T$16...
Avatar of mikecox_

ASKER

Ok, I see the problem. Glenn got it right, I am trying to import data from Master Budget 2012-2013

Paul, I tried your formula
=[Master Budget 2012-2013]Master!$T$16 but is isn't working.  I also tried
='[Master Budget 2012-2013]'Master!$T$16

Did I enter it wrong?

As I understand it, now, brackets allow the user to get data into a workbook, from a different workbook.

Anyone got an answer for
"Also, I recently put a formula in a cell but the formula displayed, not the value. How do I make the value display? "
SOLUTION
Avatar of Paul Sauvé
Paul Sauvé
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Paul: Thanks; that made it perfectly clear and very informative; now I know how to create the formula without typing it out!
Glenn ID'd the problem first and answered the second question.  
Paul explained how to generate a formula, guaranteed to be correct.
I would have given an A+ if it were available!
Thanks to you both.