Description
Calculate an internal rate of return for a series of cash flows.
Signature
RatesReturn_IRR('values', 'guess')
Parameters
| Name | Required | Type | Description |
|---|---|---|---|
| values | Yes | string array doubles | Numbers for which you want to calculate the internal rate of return. Must contain at least one positive value and one negative value to calculate the internal rate of return |
| guess | Yes | double | A number that you guess is close to the result of IRR |
Example 1
RatesReturn_IRR('-1000,240,240,240,240,240,240')