Formatting Interest rates?

[Ovatvvon]

Is there a function that will format an interest rate to a way you want it, or better, that you can use to multiply effectively to another value?

Say, a user enters a bank statement for a payment deposit and the interest. Can I take that value of the deposit (say, $1,000) and multiply it by the interest no matter if the interest is 4.5% or 12.5% Can it properly multiply it like ($1,000 * 0.125)? -Ovatvvon :-Q

 

[link9]

If you mean, like the opposite of formatPercent(), then no. Not built in, anyway. But, you could write your own... it'd be pretty simple.

function unformatPercent(theNum)
unformatPercent = theNum/100
end function

dim theAmount, theInterestRate, theTotal
theAmount = 1000
theInterestRate = 12.5
theTotal = theAmount * unformatPercent(theInterestRate)

Is that what you mean?


paul

 

[Ovatvvon]

of course...why didnt' I think of that???

thanks Paul! -Ovatvvon :-Q