L
Larryh320
I want to create a new User Defined Function to calculate compound
interest on a loan or investment. The formula is:
*F = P(1+R/N) ^ (N*T)*
Where: F = Final Amount
P = Initial Amount
R = Interest Rate
N = Number of Compounding Periods
T = Time (in years)
I have attempted this on a number of occassions and wind up with a mess
and not every close to what the result to be. A lot of times I get an
error.
I'd appreciate any help I could get with this.
Thank you.
interest on a loan or investment. The formula is:
*F = P(1+R/N) ^ (N*T)*
Where: F = Final Amount
P = Initial Amount
R = Interest Rate
N = Number of Compounding Periods
T = Time (in years)
I have attempted this on a number of occassions and wind up with a mess
and not every close to what the result to be. A lot of times I get an
error.
I'd appreciate any help I could get with this.
Thank you.