Solved

how do you variables in linreoffice calc

Posted on 2014-01-16
6
286 Views
Last Modified: 2014-01-25
I have a personal finance sheet that has the pages:
summary   <-- main page
bank
pnc inv
vanguard

I go:
DATA->DEFINE RANGE
to give my cells understandable names.  
 
From the main page (Summary) I have 4 cells:
1) =PncInterestRate
2) =InflationRate
3) =vanguardCurrentValue
4) =BankChecking

All 4 cells are defined as:
1) $'PNC Inv'.$B$6
2) $Summary.$D$2
3) $Vanguard.$B$8
4) $Bank.$B$1

The data from the main page Summary is the only one that doesn't work.  I get:
#REF!
for it.  All the other ones give the appropriate numbers.  Why can't I get data from the summary page ON the summary pae?
0
Comment
Question by:dwcronin
  • 3
  • 3
6 Comments
 
LVL 20

Expert Comment

by:ltlbearand3
ID: 39791722
Really if #2 is already on the summary page then, you should just have a value of $D$2.  If using that does not work, then please post the Calc sheet minus any confidential information and I can take a look.
0
 

Author Comment

by:dwcronin
ID: 39791904
Thank you.  I'll try to take any confidential stuff off and repost it.  The reason I deleted my question was  I could't duplicate my problems.  I'll do it today.
0
 

Author Comment

by:dwcronin
ID: 39792025
I'lll repost the question to reinstate the points.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 20

Expert Comment

by:ltlbearand3
ID: 39793337
This question appears to still have points attached to it and not be deleted.  We can still work from this question if you like.
0
 
LVL 20

Accepted Solution

by:
ltlbearand3 earned 500 total points
ID: 39793367
I think I found your other question here.  If these are the same, here is what I think is going on.  It looks like you have database ranges and sheet ranges mixed up together.  Notice here in database ranges that you have several ranges (from the menu Data >> Define Range)
Data Ranges
Now if you look at your named ranges, you will see another list:
Selecting Named RangesNotice in this list that some items have the #REF! error:
Your Named RangesThe named ranges are what you want to be set correctly for the way you are using them in formulas.  Update those values here and your sheet will work better.
EE-investments-2014-Jan-19.ods
0
 

Author Closing Comment

by:dwcronin
ID: 39809253
Thank you ltlbearand3.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Learn to move / copy / export exchange contacts to iPhone without using any software. Also see the issues in configuration of exchange with iPhone to migrate contacts.
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Viewers will learn the different options available in the Backstage view in Excel 2013.
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now