Forum Discussion
XIRR
I saw a tape from Excel University's trainer Jeff Lenning. I copied his data for irregular timing, but I get completely different results: He gets 9.60%, I get 0.095736495. Is the excel version a f...
Hi gdegaude​,
Format the result as a percentage with two decimal places and round it with formulas (see the screenshot).
=ROUND(9.5736495%, 3)
Hope this helps.
IlirU