My Excel add-in "Calculate Payments" may do what you want.
It adds a menu item to the Tools menu and displays an
input box to accept user queries.

Works for payment, term, loan amount or interest rate.
You provide any 3 of the above and it calculates the 4th.

Result displayed in a box, with one click transfer to the spreadsheet.
Comes with a one page Word.doc install/use file.
Available -free- upon direct request.
Remove XXX from my email address.

Jim Cone
San Francisco, USA
XX



"mytrebla" wrote in message
...
i would like to create a spread sheet that will amortize a 30 year loan say
at 6% and be able to figure out a monthly payment without the calculator that
i have to do my job so others only have to enter certain values and come up
with their monthly payments