Forum Discussion
Yunpeng_Shen
Jun 26, 2021Copper Contributor
复杂公式的自动填充(Automatic filling of complex formulas)
以上内容如果需要向下自动填充,表格里的公式应该如何填写?
PReagan
Jun 28, 2021Bronze Contributor
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:
Then simply add rows and helper columns as necessary.
Yunpeng_Shen
Jun 28, 2021Copper Contributor
THank you so much,I need to rethink how to ask questions.