For the interest in a specific payment:
Use the IPMT function

For the interest paid during a specific range of payments:
Use the CUMIPMT function

Both are fairly well documented in Excel Help.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Grd" wrote in message
...
Hi there,

I'd like to know how much of my mortgage payment is interest and how much
is
principle. I know my interest rate and how much I borrowed (ofcourse!) and
how much I pay each month but am wondering how to figure out what part
goes
on the interest.

Is this possible to do in Excel.?

Tx

Suzannne