How to have once cell equal a changin cell reference on another sh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One more:
=index(g:g,1+e10)

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
Click to expand...
 
Back
Top