I am using the log function to calculate a field on my form and I am getting the following error:

Error Type:
Microsoft VBScript runtime (0x800A0005)
Invalid procedure call or argument: 'log'

How can this be resolved.

Show the line of code that is causing the error.

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems
My blog... please visit

Send the code so we can try to solve your problem.

I am using the log function to calculate a field on my form and I am getting the following error:

Error Type:
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.

You cannot pass a negative value into the Log function. The result of 1-0.01333*193000/770 is a negative number. You'll have to adjust your forumla to deal with this... I am sure that has been worked out many times and someone somewhere has posted it on the internet.

Have fun

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems
My blog... please visit