| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to have once cell equal a changin cell reference on another sh
I am trying to build a sheet that will reference a mortgage sheet in the same
document. I want to be able to see the remaining balance of a mortgage by entering the number of years since the mortgage began. What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10 would be the changing number of years since the mortgage began and the G cell would be the remaining balance. So if it's 5 years since the mortgage began, I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11. Any ideas? Thanks, Nic |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to have once cell equal a changin cell reference on another sh
Try this:
=INDIRECT("G"&1+E10) Hope this helps. Pete On Sep 19, 12:06 am, Nic wrote: I am trying to build a sheet that will reference a mortgage sheet in the same document. I want to be able to see the remaining balance of a mortgage by entering the number of years since the mortgage began. What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10 would be the changing number of years since the mortgage began and the G cell would be the remaining balance. So if it's 5 years since the mortgage began, I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11. Any ideas? Thanks, Nic |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to have once cell equal a changin cell reference on anothe
Thanks Pete, fixed it right up!
Thought I might lose my hair figuring that out. Nic "Pete_UK" wrote: Try this: =INDIRECT("G"&1+E10) Hope this helps. Pete On Sep 19, 12:06 am, Nic wrote: I am trying to build a sheet that will reference a mortgage sheet in the same document. I want to be able to see the remaining balance of a mortgage by entering the number of years since the mortgage began. What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10 would be the changing number of years since the mortgage began and the G cell would be the remaining balance. So if it's 5 years since the mortgage began, I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11. Any ideas? Thanks, Nic |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to have once cell equal a changin cell reference on anothe
Thanks for feeding back, Nic - glad it worked for you.
Pete On Sep 19, 12:26 am, Nic wrote: Thanks Pete, fixed it right up! Thought I might lose my hair figuring that out. Nic "Pete_UK" wrote: Try this: =INDIRECT("G"&1+E10) Hope this helps. Pete On Sep 19, 12:06 am, Nic wrote: I am trying to build a sheet that will reference a mortgage sheet in the same document. I want to be able to see the remaining balance of a mortgage by entering the number of years since the mortgage began. What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10 would be the changing number of years since the mortgage began and the G cell would be the remaining balance. So if it's 5 years since the mortgage began, I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11. Any ideas? Thanks, Nic- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to have once cell equal a changin cell reference on another sh
INDIRECT is the missing link ..
Try it as: =INDIRECT("G"&(1+E10)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Nic" wrote: I am trying to build a sheet that will reference a mortgage sheet in the same document. I want to be able to see the remaining balance of a mortgage by entering the number of years since the mortgage began. What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10 would be the changing number of years since the mortgage began and the G cell would be the remaining balance. So if it's 5 years since the mortgage began, I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11. Any ideas? Thanks, Nic |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to have once cell equal a changin cell reference on another sh
One mo
=index(g:g,1+e10) Nic wrote: I am trying to build a sheet that will reference a mortgage sheet in the same document. I want to be able to see the remaining balance of a mortgage by entering the number of years since the mortgage began. What I've tried doing is "=G(1+E10)", which obviously didn't work, but E10 would be the changing number of years since the mortgage began and the G cell would be the remaining balance. So if it's 5 years since the mortgage began, I want the cell to equal G6. If it's 10 years, I wan the cell to equal G11. Any ideas? Thanks, Nic -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
| cHANGIN A CELL COLOUR BASED ON A CELL VALUE | New Users to Excel | |||
| Changin Cell Formats using VBA | Excel Discussion (Misc queries) | |||
| changin amount in cell | New Users to Excel | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Hybrid Mode
