FUNCTION CATALOGUE / FINANCIAL
IRR Excel function
Calculates internal rate of return.
Correct sentence to use
Calculate the internal rate of return for [cash flows].
Modify this query in PlainFormula →Example formula
=IRR(B2:B10)
Returns the internal rate of return.
Syntax
IRR(values, [guess])
Argument signature: values, [guess]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.