I tried to calculate monthly payment using Sybase but kept getting errors. Here is the formula:
p*i/[12*(1-[1+(i/12)]^-n)]
p*i = 5473.6
n = 36
i = 2.5
but i keep getting arithmetic overflow error, or truncation error when using the POWER() function. Can somebody please tell me what to do, or provide the code? Thank you very much.
p*i/[12*(1-[1+(i/12)]^-n)]
p*i = 5473.6
n = 36
i = 2.5
but i keep getting arithmetic overflow error, or truncation error when using the POWER() function. Can somebody please tell me what to do, or provide the code? Thank you very much.