I am using the log function to calculate a field on my form and I am getting the following error:
Microsoft VBScript runtime (0x800A0005)
Invalid procedure call or argument: 'log'
The line that is causing the error is X = ((-log(1-0.01333*193000/770)/log(1+0.01333))/12) this is an example.
I am trying to determine the term of a loan given the monthly interest rate, the loan amount and the monthly payment amount.
The formula to determine the term of a loan is: loanTerm = ((-log(1-monthlyInterest*loanAmount/monthlyLoanPayment)/log(1+monthlyInterest))/12)
Thanks in advance.