=SUM(LOOKUP(5,A1:A8,B1:B8),LOOKUP(5,A2:A9,D2:D9))是什么意思
=SUM(LOOKUP(5,A1:A8,B1:B8),LOOKUP(5,A2:A9,D2:D9))是什么意思
LOOKUP函数求助=LOOKUP(A2,{0,1,2,3,4,5;"0%","2%","4%","6%","8%","
如A1为=AVERAGE(A2:A8) B1为=AVERAGE(B2:B8) 现在C1要用A1和B1平均 =AVERAG
您好,=LOOKUP(1,0/(A1:A17=1),B1:B17)的解释,
在excel中如何编辑公式求B1=SUM(A1:A2),B2=SUM(A3:A5),B3=SUM(A6:A9)……每次求
=lookup(A1,sheet1!A:A,sheet1!B:B)中的A1是什么意思,sheet1!A:sheet1!B
excel =-LOOKUP(,-MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&12
已知an为等差数列,若a1 a2 a3=5,a7 a8 a9=10,则a19 a20 a21=
在等比数列an中,a1+a2+a3+a4+a5=5,a6+a7+a8+a9+a10=-1
EXCEL中公式前面的"-"是什么意思?比如说:1:=-LOOKUP(,-RIGHT(A1,ROW($1:$9)))
excel 函数问题:=-LOOKUP(,-MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},
EXCEL 公式实现 A1=A2=A3=B1;A4=A5=A6=B2;A7=A8=A9=B3...