need help referencing cell by formula result

  • Thread starter Thread starter nosliw
  • Start date Start date
N

nosliw

I am trying to select a cell to reference using the result of a formula
The spread sheet is an intrust calculator and I am wanting to bring th
balance of the loan from say 6 months from =TODAY() to a cell. Th
balance column shows the compounded intrust and subtracted payment
month after month from the begining of the loan. I have a formula t
find the coresponding row number for any month I wish to see th
balance. I've tried =ADDRESS and some other things I'm not sure how t
use. Any suggestions. Thank
 
Maybe take a look at INDIRECT in help. Otherwise, post more detail.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CUMIPMT 0
Help to create amortization schedule 0
Building closed workbook file path within an Index Function 6
Date function within loan amortization spreadsheets 3
Microsoft's Loan Amortization template 5
Annual Payment Formula if Variable Interest Rate can change Monthl 2
Loan - extra payment benefit formula Part 2 2
First row where a cell is zero 1

Back
Top