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

%3CLINGO-SUB%20id%3D%22lingo-sub-2487781%22%20slang%3D%22zh-CN%22%3EAutofill%20of%20complex%20formulas%20(Automatic%20filling%20of%20formula%20formulas)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2487781%22%20slang%3D%22zh-CN%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yunpeng_Shen_0-1624699302855.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F291582i145B51D3CF6A0A6D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yunpeng_Shen_0-1624699302855.png%22%20alt%3D%22Yunpeng_Shen_0-1624699302855.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20the%20above%20needs%20to%20be%20auto-populated%20down%2C%20how%20should%20the%20formulas%20in%20the%20form%20be%20filled%20in%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2487781%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2493175%22%20slang%3D%22en-US%22%3ERe%3A%20%E5%A4%8D%E6%9D%82%E5%85%AC%E5%BC%8F%E7%9A%84%E8%87%AA%E5%8A%A8%E5%A1%AB%E5%85%85%EF%BC%88Automatic%20filling%20of%20complex%20formulas%EF%BC%89%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2493175%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1088539%22%20target%3D%22_blank%22%3E%40Yunpeng_Shen%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20might%20not%20be%20the%20answer%20that%20you're%20looking%20for%2C%20however%2C%20I'll%20give%20it%20a%20try...%3CBR%20%2F%3EWith%20the%20%22m%22%20values%20placed%20in%20column%20A%2C%20you%20could%20use%20helper%20columns%20to%20the%20right%20of%20A%20to%20create%20each%20addition%20to%20the%20sequence.%20In%20each%20helper%20column%2C%20you%20could%20use%20the%20formula(s)%3A%3C%2FP%3E%3CPRE%3E%3D%24A%241%5EROW(%24A1)%3B%20%3D%24A%242%5EROW(%24A1)%3B%20%3D%24A%243%5EROW(%24A1)%3B%20%3D%24A%244%5EROW(%24A1)%20and%20so%20on...%3C%2FPRE%3E%3CP%3ETake%20for%20example%20the%20following%20image%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PReagan_0-1624894607451.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F291924i25C33B228D1E827C%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PReagan_0-1624894607451.png%22%20alt%3D%22PReagan_0-1624894607451.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20simply%20add%20rows%20and%20helper%20columns%20as%20necessary.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.