Question

excel 有A1-A100,已知和为350000，A1为25，A2/A1=A3/A2，依次类推，求A2-A100的数值，求大神帮忙！

急求

Answer 1

根据等比数列求和公式

所以q=1.0715479,然后，A2-A100的数值以此类推...

Answer 2

A2输入8，A3=A2^2/A1，下拉至A100，B1输入=sum(A1:A100)
工具—单变量求解：
目标单元格：B1
目标值350000
可变单元格A2
确定。
得A2-A100=-23366.2

Answer 3

A1-A100=
25
26.78869705
28.70537159
30.75918012
32.95993431
35.31814781
37.84508648
40.55282226
43.4542908
46.56335327
49.89486258
53.46473432
57.29002282
61.38900261
65.78125573
70.48776525
75.53101556
80.93509975
86.72583471
92.9308845
99.57989246
106.7046229
114.3391126
122.519834
131.2858686
140.6790944
150.7443857
161.5298272
173.0869442
185.4709485
198.741002
212.9604997
228.1973725
244.5244111
262.0196148
280.7665633
300.8548163
322.3803412
345.4459718
370.1618994
396.6461993
425.0253948
455.4350616
488.0204756
522.937307
560.3523637
600.4443885
643.4049128
689.4391716
738.7670841
791.6243042
848.2633465
908.9547923
973.9885826
1043.675403
1118.348167
1198.36361
1284.103988
1375.978909
1474.427285
1579.919435
1692.959324
1814.086978
1943.881059
2082.961632
2231.993125
2391.687506
2562.807681
2746.171142
2942.653871
3153.194523
3378.798913
3620.544819
3879.587132
4157.163375
4454.599609
4773.316777
5114.837482
5480.793271
5872.932421
6293.128297
6743.388297
7225.863448
7742.858673
8296.843812
8890.465414
9526.559384
10208.16453
10938.53708
11721.16624
12559.79086
13458.4173
14421.33855
15453.15478
16558.79527
17743.542
19013.05485
20373.39866
21831.07218
23393.03916

Answer 4

这是个等比数列，

q=1.071547880562

用excel算的。。

Answer 5

有解，数据大，看附件。