复杂公式的自动填充(Automatic filling of complex formulas)

Copper Contributor

Yunpeng_Shen_0-1624699302855.png

以上内容如果需要向下自动填充,表格里的公式应该如何填写?

2 Replies

Hello @Yunpeng_Shen,

 

This might not be the answer that you're looking for, however, I'll give it a try...
With the "m" values placed in column A, you could use helper columns to the right of A to create each addition to the sequence. In each helper column, you could use the formula(s):

=$A$1^ROW($A1); =$A$2^ROW($A1); =$A$3^ROW($A1); =$A$4^ROW($A1) and so on...

Take for example the following image:

PReagan_0-1624894607451.png

Then simply add rows and helper columns as necessary.

 

 

THank you so much,I need to rethink how to ask questions.