Hi all

Here is a tricky question;

I'm doing some mortgage calculations using Excel's PMT formula, currently what I've been doing is this;

I have an input sheet with my raw data - I then process the raw data in another sheet, where I'm doing numerous calculations. One of those is the PMT. So far I've been using a fixed loan period, based on estimates, but I would like to use the real periods instead - Is it possible to insert a reference based on a for next in a formula, like the PMT?

/Nick