I have a question on how the IRR function thinks. In the case of where there
are multiple outflows and inflows at various points in time like below which
causes multiple results, is the result displayed the number closest to 10%?
How does it decide what answer to give you?

Period 1 -1,000
Period 2 6,000
Period 3 -11,000
Period 4 6,000

Thanks,

Carrie