LOOKUP函数求助=LOOKUP(A2,{0,1,2,3,4,5;"0%","2%","4%","6%","8%","
来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/07/14 14:34:32
LOOKUP函数求助
=LOOKUP(A2,{0,1,2,3,4,5;"0%","2%","4%","6%","8%","10%"}) “0%”要引用C2的数据,“2%”要引用C3的数据,“4%”要引用C3的数据,“6%”要引用C4的数据,“8%”要引用C5的数据,“10%”要引用C6的数据,我写了个公式LOOKUP(A2,{0,1,2,3,4,5},{C2,C3,C4,C5,C6,C7})哪里错了,请教是哪里错了?1
=LOOKUP(A2,{0,1,2,3,4,5;"0%","2%","4%","6%","8%","10%"}) “0%”要引用C2的数据,“2%”要引用C3的数据,“4%”要引用C3的数据,“6%”要引用C4的数据,“8%”要引用C5的数据,“10%”要引用C6的数据,我写了个公式LOOKUP(A2,{0,1,2,3,4,5},{C2,C3,C4,C5,C6,C7})哪里错了,请教是哪里错了?1
=LOOKUP(A2,{0,1,2,3,4,5},C2:C7)
用{}表示的只能是常量数组
用{}表示的只能是常量数组
LOOKUP函数求助=LOOKUP(A2,{0,1,2,3,4,5;"0%","2%","4%","6%","8%","
excel 函数问题:=-LOOKUP(,-MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},
excel =-LOOKUP(,-MID(A1,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A1&12
=LOOKUP(9^9,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&5^19)
LOOKUP函数=LOOKUP(1,0/(C22:AAA22>0),C22:AAA22)
EXCEL公式 =LOOKUP(2,0/(1:1""),1:
LOOKUP函数中1,0是什么作用
lookup函数=LOOKUP(1,0/($A$1:A6=$A7),$B$1:$B6)得到的是=LOOKUP(1,0/(
如何使用lookup函数$A$2:
=SUM(LOOKUP(5,A1:A8,B1:B8),LOOKUP(5,A2:A9,D2:D9))是什么意思
请问这个函数的意思是什么啊=LOOKUP(A2,{0,10000,30000,50000},{0,0.05,0.1,0.
lookup函数里的1,