Try PMT(), read up on it.
Jeff Wrote:
I need a formula to calculate the payments based on loan amount,
interest
rate and term of the loan. This is for mortgage payments
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=507497