Forum Discussion

Yunpeng_Shen's avatar
Yunpeng_Shen
Copper Contributor
Jun 26, 2021

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

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

2 Replies

  • PReagan's avatar
    PReagan
    Bronze 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's avatar
      Yunpeng_Shen
      Copper Contributor
      THank you so much,I need to rethink how to ask questions.

Resources