ExcelBanter - how to calculate Rate when PMT, Nper & PV is known

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to calculate Rate when PMT, Nper & PV is known (https://www.excelbanter.com/excel-worksheet-functions/104612-how-calculate-rate-when-pmt-nper-pv-known.html)

Jess

how to calculate Rate when PMT, Nper & PV is known

how to calculate Rate when PMT, Nper & PV is known

Bearacade

how to calculate Rate when PMT, Nper & PV is known

Use RATE(nper,pmt,pv)

Check the help files on it

--
Bearacade

------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=570909

Martin P

how to calculate Rate when PMT, Nper & PV is known

Remember to let PMTand PV have opposite signs.

"Jess" wrote:

how to calculate Rate when PMT, Nper & PV is known

All times are GMT +1. The time now is 12:43 PM.