PMT function

B

Bruce Baker

Hi

I need to port this to a sql server script.

Is there anyplace I can get the source for this ?

Thanks
Bruce
 
B

Bruce Baker

Thanks - if only my schoolboy maths could work out to get PMT to the left
hand side of the equation...
 
N

Norman Harker

Hi Bruce!

Re-expressed for PMT the formula is:

PMT = =-(PV*(1+RATE)^NPER+FV)/((1+RATE*TYPE)*(((1+RATE)^NPER-1)/RATE))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
 
Top