Thread: =RATE(17,1,-5) returns #NUM! but the answer should be about 18.9
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hapster
 
Posts: n/a
Default =RATE(17,1,-5) returns #NUM! but the answer should be about 18.9
Is there a way to get this function to generate the correct answer?
Essentially, I am trying to get the IRR for a cash for of $1 per year for 17
years given a $5 investment. My calculator gives the answer but I want to
program into Excel.


Reply With QuoteReply With Quote