IRR

IRR(arg1, arg2) → { number | string | boolean }

Returns the internal rate of return for a series of cash flows.

Parameters:

Name Type Description
arg1 ApiRange

Is an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.

arg2 number

Is a number that you guess is close to the result of IRR; 0.1 (10 percent) if omitted.

Returns:

Type
number | string | boolean