Cell reference within array
Harlan Grove wrote:
wrote...
...
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)
...
Excel prohibits this because IRR takes a single argument, but you're
trying to pass 5 arguments.
IRR accepts array first arguments, so make this an array.
=IRR(IF({1;0;0;0;0},A8,50))
Nice!
|