Re: Oilstructure - oilstructure.com
Lomal golovu nad raschetom kompaunda 100%-go v Excel --- i smog sozdat' poluavtomaticheskuyu formulu:
=(A1/100)*2+A1,
gde A1 -- eto nash vklad. (Tak vygl'adit formula dlya 2-go dnya).
Dlya 3-go dnya analogichno:
=(A2/100)*2+A2,---
to est' nomer dnya postoyanno na 1 bol'she, chem chislo vozle A (A2-- dlya 3-go, A3--- dlya 4-go i t.d.)
vot primer dlya vklada $100 za 7 dney:
100 (vklad, A1)
102 (2-y den')
104.04 (3-y)
106.12 (4-y)
108.24 (5-y)
110.40 (6-y)
112.61 (7-y)
Nomer vozle A prixodilos' men'at' vruchnuyu, formulu kopirovat' --- mojet kto-to pomnit kak prosche --- napishyte.