dwcronin
asked on
how do you variables in linreoffice calc
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?
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?
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.
ASKER
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.
ASKER
I'lll repost the question to reinstate the points.
This question appears to still have points attached to it and not be deleted. We can still work from this question if you like.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you ltlbearand3.