Become a MacRumors Supporter for $25/year with no ads, private forums, and more!

Madhatter32

macrumors 6502
Original poster
Apr 17, 2020
299
913
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.
 

Madhatter32

macrumors 6502
Original poster
Apr 17, 2020
299
913
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.
 
Comment

rajeshmetla

macrumors newbie
Sep 11, 2020
1
1
India
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.
Screenshot 2020-09-11 at 12.50.56 PM.png
 
  • Like
Reactions: Madhatter32
Comment

Madhatter32

macrumors 6502
Original poster
Apr 17, 2020
299
913
Wow. Thanks so much for the update. I have been waiting for this for a very long time. I feel liberated!
 
  • Like
Reactions: rajeshmetla
Comment
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.