While I appreciate your reply, I would have no idea how to go about implementing this in LF Forms.  I suppose it would take some javascript but that's not my forté, so I'm hoping someone on the forum has done something similar and can share their solution.

Thanks!

Hi Mike, do you have an example of what fields and calculations you use to calculate IRR in Excel? Can you provide an Excel sheet as an example?
 

Sure, please see the attached file and refer to cell G52 which has the following formula:  =IF(SUM(H38:R44)>0,IRR(G45:R45,-0.99999),0)

Hi Mike

After doing some investigation and with the lack of an IRR formula in Forms, it appears the only way to really pull this off would be code this via Javascript unless you went with a different form of calculation to get to a similar result to IRR without it being IRR.

Thanks for looking into this Steve.  I figured that javascript might be the best solution and I do think there's a library of financial formulas available somewhere that can be called by a script function.  I've asked my VAR to take a look at it too...was just hoping someone on here had already done it.

Thanks!

We did this for a client, most of the libraries out there do not match up with what you will get out of excel, so do not expect an exact match since IRR is an iterative solution without an exact answer and different libraries do it differently.

We did find this repository that tried to copy and get what Excel used. When we adapted it to forms, and it was a fairly close match and the client was happy.  https://github.com/kgkars/tvm-financejs