Hi Guys,
How do I use the PPMT function to return the princple from payments 1-12 combined?
is working fine for the first payment, but I want it to return payments 1 - 12. If I useFormula:Please Login or Register to view this content.it works fine, but thought there would be an easier way.Formula:Please Login or Register to view this content.
I'm trying to work out how much principle I have each year, rather than monthly basis.
Thanks in advance.
Bookmarks