本金一万元,每次加10%.即1+1.1+1.21+1.331.要到第几次结果才接近50万?求公式,详解.上面题目说错了,是本金一万元,每次加10%.即1,1.1,1.21,1.331.要递增到第几次结果才接近50万?求公式,详解.

Question

本金一万元,每次加10%.即1+1.1+1.21+1.331.要到第几次结果才接近50万?求公式,详解.
上面题目说错了,是本金一万元,每次加10%.即1,1.1,1.21,1.331.要递增到第几次结果才接近50万?求公式,详解.

Answer 1

42次,在excel的A1输入1,在A2输入：=1.1*A1,然后把公司往下拉.
1
1.1
1.21
1.331
1.4641
1.61051
1.771561
1.9487171
2.14358881
2.357947691
2.59374246
2.853116706
3.138428377
3.452271214
3.797498336
4.177248169
4.594972986
5.054470285
5.559917313
6.115909045
6.727499949
7.400249944
8.140274939
8.954302433
9.849732676
10.83470594
11.91817654
13.10999419
14.42099361
15.86309297
17.44940227
19.1943425
21.11377675
23.22515442
25.54766986
28.10243685
30.91268053
34.00394859
37.40434344
41.14477779
45.25925557
49.78518112
54.76369924