Hi Team
I need to compute cell by cell XIRR . So for example, first IRR will be calculated from FY21 to FY 22, FY21 to FY 23 . them FY21 to FY24 and goes on and on. Is there a way to achieve this?
So its an expanding calc starting with FY21 and keeps on expanding by brining in additional year.
Thanks
Musab
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/6b82a7d6-72f1-4a6e-9ddc-f3b3208be2e0.png)