Re: Using Rate Function to Calculate APR% for a Lease

Please show the code you were attempting. It may help to provide what kind of "RATE" you are looking for since Finance stuff has a plethora of rates.

If you used the Finance('RATE', ....) function that calculates the interest rate of an annuity. Is that what you wanted? It seems unlikely given the name of your variables Financed_Amount and Lease_residual