Are you looking to build a mortgage calculator in Excel? The PMT function is probably what you are looking for. This tutorial will walk you through the basics of creating a mortgage calculator. Keep in mind you can replace the values in the formula with cell locations.

Link:
http://office.microsoft.com/assistance/preview…..