Forum Discussion
Internal Rate of Return (IRR)
Hi, everyone, is there anyone who knows source algorithm for IRR function? I am trying to implement IRR function within Power Apps. Did not find any official documentation for IRR excel function...
Afraid such documentation doesn't exist, Microsoft doesn't share concrete algorithms.
Some guesses are here
algorithm - Implementing Excel and VB's IRR function - Stack Overflow
Internal Rate of Return Calculation
Hello @Sergei,
Thank you for your feedback. After all I was not able to reproduce the IRR function but I was able to use OfficeScripts in Power Automate to achieve IRR. I am sending array of values which are then processed via "Run script" action.
Best regards
Krystof
Thank you for your feedback. After all I was not able to reproduce the IRR function but I was able to use OfficeScripts in Power Automate to achieve IRR. I am sending array of values which are then processed via "Run script" action.
Best regards
Krystof