1

Topic: Exponentiation

Good afternoon !
All we can not write in any way correctly here this formula on  a BASIC. 1 / ((1+r/1200)  ^ (12y+m)-1)
Help . How correctly to write
Thanks

2

Re: Exponentiation

Show the attempts...

3

Re: Exponentiation

s = S0 * (r * (12 * y + m) / 1200) * (1 + (1 / (1 + r / 1200) ^ (12 * y + m) - 1)). Here please

4

Re: Exponentiation

Well it is normal, to the formula corresponds.
And what not so?

5

Re: Exponentiation

In the first fraction for certain r ^ (12 * y + m)
The many-storeyed recursive fraction in brackets can there?

6

Re: Exponentiation

Akina wrote:

Well it is normal

not, there is a jamb, it is necessary to take a denominator of the second fraction in the general brackets

7

Re: Exponentiation

This formula  payment. In the credit calculator value does not coincide with my calculator. For example at the total of 1 000 000 roubles, for two years, at the rate of 19 % in annual, quits 50 408.62, and at me 260 242.10. Here I can not understand, what not so

8

Re: Exponentiation

daur-8305;
Instead of it will be easier separate members of expression to scatter on different variables and  to fence super-difficult expressions for perception?
Variables too for something invented...

9

Re: Exponentiation

Dim r, y, m, s0
Dim s
Dim ym12, s1200, r1200
ym12 = 12 * y + m
s1200 = s0 * r * ym12 / 1200
r1200 = (1 + r / 1200) ^ ym12 - 1
s = s1200 * (1 + 1 / r1200)

10

Re: Exponentiation

Thanks. But the result quitted absolutely another. Probably with the formula that that not so

11

Re: Exponentiation

daur-8305;
To subtract unit it is necessary not from a level, and from result of exponentiation.

12

Re: Exponentiation

Thanks all. Solved a problem under other formula.
Do not prompt how to make so that in textbox at a dial-up of great sums zero were divided, that is after three zeroes there were commas or a gap?

13

Re: Exponentiation

Masked Edit Control