View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How to use RATE function?

See answer in other newsgroup

Please do not post in separate posts to different newsgroups

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Eric" wrote in message ...
|I get mortage loan $63000, and I need to pay $2276 every 3 months for 15 years.
| Does anyone know on how to determine the interest rate using RATE function?
|
| =RATE(60,2276,0,-63000) = -3%, which don't seem right
|
| Does anyone know how to apply RATE function in this case?
| Could anyone please give me any suggestion?
| Thank for any suggestion
| Eric
|