asked on
Excel RATE() function algorithm
I am looking for the algorithm used to define the RATE() function in excel. I'd prefer it to be in ruby.
It needs to have the same params as the excel function: RATE( number_payments, payment, PV, FV, Type, Estimate ). FV, Type and Estimate seem to be optional as they take default values.
This doesn't seem to do the trick for me: https://www.experts-exchange.com/questions/20531809/Looking-Excel-RATE-in-javascript-or-Algorithm.html
It needs to have the same params as the excel function: RATE( number_payments, payment, PV, FV, Type, Estimate ). FV, Type and Estimate seem to be optional as they take default values.
This doesn't seem to do the trick for me: https://www.experts-exchange.com/questions/20531809/Looking-Excel-RATE-in-javascript-or-Algorithm.html
RubyAlgorithmsMicrosoft Excel
Last Comment
James Murrell
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.