IRR

Returns the Internal Rate of Return for a supplied series of periodic cash flows.
=IRR(B1:B4)
IRR() Result is -13.62%
=IRR(B1:B6)
IRR() Result is 13.06%