IRR in Collabora Office: Find a Return Rate for Regular Cash Flows

=IRR(Values [; Guess])

Values is the cash-flow array. The vendor requires at least one negative value, representing a payment, and at least one positive value, representing income. Cash flows must be at regular intervals. Guess is an optional starting estimate for the iterative calculation; the dedicated section does not state an omitted default.

For irregularly dated payments, the vendor directs readers to XIRR. IRR has no date argument and cannot infer whether the interval is a month, quarter, or year from a label beside the values.

The source says text and empty cells in a data range are ignored. Preserve an actual zero cash-flow period as numeric 0 rather than leaving its place blank.

Enter −100, 60, 60 into A2:A4, in chronological order. In C2 use:

=IRR(A2:A4;0.1)

The independent root is approximately 0.130662386292. Check it with:

=A2+A3/(1+C2)+A4/(1+C2)^2

The independent residual is approximately zero. The first payment is at time zero; later values are discounted by one and two periods respectively.

Use the unrounded rate in the check. A residual formed with a rounded displayed percentage can be nonzero simply because the rate lost precision. ABS is useful for inspecting residual magnitude.

For −10000, 3500, 7600, 1000, the help gives an IRR of 11.33%. Enter those values in E2:E5 and use =IRR(E2:E5).

An independent root calculation gives approximately 11.332102824%, consistent with the documented two-decimal percentage. This is a rate per cash-flow interval, not automatically an annual percentage.

For −100, 0, 121, the independent IRR is 10%, since 121/(1.1)²=100. The zero occupies the first period after the initial payment; the receipt occurs two periods later.

If that zero is replaced by a blank that is ignored, the modeled series no longer clearly preserves the two-period timing. Do not use blanks as a visual substitute for known zero cash flow. An omitted observation and a known zero have different modeling meanings.

For a separate one-month control −100,101, the period rate is 1%. Assuming twelve identical monthly compounding periods, the independent annualized rate is (1.01)^12−1, approximately 12.682503013%. That annualization assumption belongs to the model, not to IRR’s syntax.

The series −100,230,−132 has two independent valid rates, 10% and 20%, because both satisfy:

=-100+230/(1+rate)-132/(1+rate)^2

The source says IRR is iterative. A starting guess can influence numerical search, but this guide does not claim which native root any particular Guess selects. A returned number is not proof that it is the only possible IRR or the economically appropriate summary.

Inspect sign changes and validate the resulting discount equation. For cash flows with multiple sign changes, consider the ambiguity before using one rate as the sole decision measure.

The vendor explicitly warns that IRR can fail with Error 523, “Calculation does not converge,” and suggests trying another Guess. Before doing so, verify signs, timing, numeric types, and cash-flow order. Changing Guess cannot repair an incorrectly modeled series.

Do not type cash outflows as positive unless the entire sign convention is intentionally reversed. Numeric text may be ignored according to the source. SUM can check net cash flow, but a positive total alone does not determine the return rate.

The guide does not certify all coercion rules, native root-selection behavior, or numerical limits. Worked rates are independent calculations and documentation controls, not a recommendation concerning any actual investment.

The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.

The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.

• Collabora Office 26.04: IRR (checked October 17, 2026).
• Editorial testing standards.