Try this:

Loan 50,000.00
PMT -5,872.98
i 10.00%
n 20 < =NPER(B3,B2,B1)

Assume the data for for loan start in B1. The formula in B4 that returns
the number of periods is shown above.

Pieter Vandenberg

Anita wrote:
: In Excel I know how to calculate a monthly repayment using PMT but is there
: any way I can calculate how long a loan would take to pay off )this is a
: question I've been asked and I'm not sure whether it can be done or not).

: I thought maybe goal seek but you can only use that on a cell containing a
: formula.

: Any ideas gratefully received.

: Many thanks

: Anita