One way:

A
1 -5
2 1
3 1
....
18 1

20 =IRR(A1:A18) === 18.95%


Alternatively,

=IRR({-5,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1})


In article ,
hapster wrote:

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.