XIRR

If you want to see this exact value (9.57%), here is the formula...

=ROUND(0.095736495, 4)

But in practice, don't hardcode the number. Use:

=ROUND(XIRR(values, dates), 4)

That way it stays dynamic — if your cash flows or dates change, the rounding still works automatically.

Decimal:     0. 0  9  5  7  3  6  4  9  5

             ^  ^  ^  ^  ^

             |  |  |  |  |

             |  |  |  |  └── 4th decimal = 7  (round here)

             |  |  |  └───── 3rd decimal = 5

             |  |  └──────── 2nd decimal = 9  → becomes 9.57% in percentage

             |  └─────────── 1st decimal = 0

             └────────────── ones = 0

• 2 percentage decimals (9.57%) = 4 decimal places in the raw decimal (0.0957)
• So ROUND(..., 4) gives you exactly the precision needed for 9.57%

I hope this helps.

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