Apple Numbers: XIRR function

[Madhatter32]

Like many, I am now working from home and am using my MBP to do more work related tasks. I am on High Sierra and working with Numbers 6.1. I am using it more and more and really like it. I usually use Excel at work but would like to gravitate to using more Apple software, especially since it comes with the hardware and is easy to use. Does the newer Numbers 10 include the XIRR function yet? For me to consider using Numbers, I need this function and would even upgrade to a newer version (OS if necessary) if I could get it. Thanks.

 

[Mitthrawnuruodo]

I have Numbers 10.0 (the newest) and there's no XIRR function there.

There is IRR and MIRR, though, but I guess that's not good enough?

 

[Madhatter32]

I have Numbers 10.0 (the newest) and there's no XIRR function there.

There is IRR and MIRR, though, but I guess that's not good enough?

Thanks for letting me know! Those are good but I need the XIRR. It's not a total game changer though. I can still use Numbers for many projects. Hopefully they will incorporate this function sometime in the future. I think it's available in Libre office so maybe I'll look at that for those tasks.

 

[rajeshmetla]

I'm using Numbers 10.1. It has got the XIRR Formula in it. I was also waiting for it. And it was finally over.

 

[Madhatter32]

Wow. Thanks so much for the update. I have been waiting for this for a very long time. I feel liberated!