exponential calculation (1 Viewer)

[legendv]

I don't know
how to programmaticaly code exponents. The formula is
this:
P = A * (F-1) / (1-F_n)

What I mean by _n is "F to the negative n" such as a value
with a negative exponent. n is actually a value the user
keys in. The rest of the formula is simplistic, but I
don't know how to write the code for negative exponents.
Does anyone out there know? A million future thank you's,
if anyone responds.
Jon

 

[Pat Hartman]

The answer from help is:

This example uses the ^ operator to raise a number to the power of an exponent.

Dim MyValue
MyValue = 2 ^ 2 ' Returns 4.
MyValue = 3 ^ 3 ^ 3 ' Returns 19683.
MyValue = (-5) ^ 3 ' Returns -125.

 

[legendv]

Thanks Pat, I'll try it tomorrow.

 

[legendv]

Pat - this is the formula:

[AmtFinanced]*((1+(([IR]/100)/12))-1)/(1-(1+(([IR]/100)/12)^-([term])))

It seems to work except when trying the ^ or the Exp commands. All I want is to make the [term] a negative exponent. I can't seem to get it straight. Any suggestions?

The soulution should be your monthly payment.
[IR] is Interest Rate
[Term] is Length of loan in months
[AmtFinanced] is The Amount Borrowed/Financed
In the prior thread
F = (1+(([IR]/100)/12))

Please help!

[This message has been edited by legendv (edited 04-02-2002).]

[This message has been edited by legendv (edited 04-02-2002).]