【小试牛刀】(ID:88165)

更新于 2026年10月13日 版权声明
【小试牛刀】(ID:88165)

为了方便读者操作,可打开ID为88165的课件,这里有已经作好的从a1~a100的100个变量,你可先另存为自己的文件,然后体会什么是批量操作、什么是批量修改、什么是迭代嵌套先提取.

附:(m6、m7、m8的表达式)

m6:

if(t<1,a1,t<2,a2,t<3,a3,t<4,a4,t<5,a5,t<6,a6,t<7,a7,t<8,a8,t<9,a9,t<10,a10,t<11,a11,t<12,a12,t<13,a13,t<14,a14,t<15,a15,t<16,a16,t<17,a17,t<18,a18,t<19,a19,t<20,a20,t<21,a21,t<22,a22,t<23,a23,t<24,a24,t<25,a25,t<26,a26,t<27,a27,t<28,a28,t<29,a29,t<30,a30,t<31,a31,t<32,a32,t<33,a33,t<34,a34,t<35,a35,t<36,a36,t<37,a37,t<38,a38,t<39,a39,t<40,a40,t<41,a41,t<42,a42,t<43,a43,t<44,a44,t<45,a45,t<46,a46,t<47,a47,t<48,a48,t<49,a49,t<50,a50,t<51,a51,t<52,a52,t<53,a53,t<54,a54,t<55,a55,t<56,a56,t<57,a57,t<58,a58,t<59,a59,t<60,a60,t<61,a61,t<62,a62,t<63,a63,t<64,a64,t<65,a65,t<66,a66,t<67,a67,t<68,a68,t<69,a69,t<70,a70,t<71,a71,t<72,a72,t<73,a73,t<74,a74,t<75,a75,t<76,a76,t<77,a77,t<78,a78,t<79,a79,t<80,a80,t<81,a81,t<82,a82,t<83,a83,t<84,a84,t<85,a85,t<86,a86,t<87,a87,t<88,a88,t<89,a89,t<90,a90,t<91,a91,t<92,a92,t<93,a93,t<94,a94,t<95,a95,t<96,a96,t<97,a97,t<98,a98,t<99,a99,t<100,a100)(https://www.daowen.com)

m7:

if(k<1,a1,k<2,a2,k<3,a3,k<4,a4,k<5,a5,k<6,a6,k<7,a7,k<8,a8,k<9,a9,k<10,a10,k<11,a11,k<12,a12,k<13,a13,k<14,a14,k<15,a15,k<16,a16,k<17,a17,k<18,a18,k<19,a19,k<20,a20,k<21,a21,k<22,a22,k<23,a23,k<24,a24,k<25,a25,k<26,a26,k<27,a27,k<28,a28,k<29,a29,k<30,a30,k<31,a31,k<32,a32,k<33,a33,k<34,a34,k<35,a35,k<36,a36,k<37,a37,k<38,a38,k<39,a39,k<40,a40,k<41,a41,k<42,a42,k<43,a43,k<44,a44,k<45,a45,k<46,a46,k<47,a47,k<48,a48,k<49,a49,k<50,a50,k<51,a51,k<52,a52,k<53,a53,k<54,a54,k<55,a55,k<56,a56,k<57,a57,k<58,a58,k<59,a59,k<60,a60,k<61,a61,k<62,a62,k<63,a63,k<64,a64,k<65,a65,k<66,a66,k<67,a67,k<68,a68,k<69,a69,k<70,a70,k<71,a71,k<72,a72,k<73,a73,k<74,a74,k<75,a75,k<76,a76,k<77,a77,k<78,a78,k<79,a79,k<80,a80,k<81,a81,k<82,a82,k<83,a83,k<84,a84,k<85,a85,k<86,a86,k<87,a87,k<88,a88,k<89,a89,k<90,a90,k<91,a91,k<92,a92,k<93,a93,k<94,a94,k<95,a95,k<96,a96,k<97,a97,k<98,a98,k<99,a99,k<100,a100)

m8:

if(m<=1,a1,m<=2,a2,m<=3,a3,m<=4,a4,m<=5,a5,m<=6,a6,m<=7,a7,m<=8,a8,m<=9,a9,m<=10,a10,m<=11,a11,m<=12,a12,m<=13,a13,m<=14,a14,m<=15,a15,m<=16,a16,m<=17,a17,m<=18,a18,m<=19,a19,m<=20,a20,m<=21,a21,m<=22,a22,m<=23,a23,m<=24,a24,m<=25,a25,m<=26,a26,m<=27,a27,m<=28,a28,m<=29,a29,m<=30,a30,m<=31,a31,m<=32,a32,m<=33,a33,m<=34,a34,m<=35,a35,m<=36,a36,m<=37,a37,m<=38,a38,m<=39,a39,m<=40,a40,m<=41,a41,m<=42,a42,m<=43,a43,m<=44,a44,m<=45,a45,m<=46,a46,m<=47,a47,m<=48,a48,m<=49,a49,m<=50,a50,m<=51,a51,m<=52,a52,m<=53,a53,m<=54,a54,m<=55,a55,m<=56,a56,m<=57,a57,m<=58,a58,m<=59,a59,m<=60,a60,m<=61,a61,m<=62,a62,m<=63,a63,m<=64,a64,m<=65,a65,m<=66,a66,m<=67,a67,m<=68,a68,m<=69,a69,m<=70,a70,m<=71,a71,m<=72,a72,m<=73,a73,m<=74,a74,m<=75,a75,m<=76,a76,m<=77,a77,m<=78,a78,m<=79,a79,m<=80,a80,m<=81,a81,m<=82,a82,m<=83,a83,m<=84,a84,m<=85,a85,m<=86,a86,m<=87,a87,m<=88,a88,m<=89,a89,m<=90,a90,m<=91,a91,m<=92,a92,m<=93,a93,m<=94,a94,m<=95,a95,m<=96,a96,m<=97,a97,m<=98,a98,m<=99,a99,m<=100,a100)

✍AI写作