I am trying to use a cell reference within an array, but Excel won't
let me.

In my case, here is the formula I want: =IRR(A8,50,50,50,50)

A8 is a negative number that will change by row: the next line would
read =IRR(A9,50,50,50,50)

Ideas?