IRR Formula

[Manos]

Dear All,


I am trying to use the IRR Formula but i have a problemm

if i use =IRR({-5000;2000;3000;4000})
I AM HAVING 32%

I want insted of insert manual the figures in the formula
to have links to cell. More specific not having -5000 but
B5

Is that possible?

Thanks in advance Manos

 

[Lucas Karpiuk]

Hi Manos,

The IRR function supports using a cell range.

For example, =IRR(B5:B8)

 

[LanceB]

A
1 -5000
2 2000
3 3000
4 4000

=IRR(A1:A4)