早教吧作业答案频道 -->其他-->
EXCEL公式内大括号里面的数字太长了怎么办?LOOKUP(Sheet1!$B3,Sheet2!$A$8:$A$97,{8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,
题目详情
EXCEL公式内大括号里面的数字太长了怎么办?
LOOKUP(Sheet1!$B3,Sheet2!$A$8:$A$97,{8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97})
LOOKUP(Sheet1!$B3,Sheet2!$A$8:$A$97,{8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97})
▼优质解答
答案和解析
公式精简为这样:
=LOOKUP(Sheet1!$B3,Sheet2!$A$8:$A$97,ROW($8:$97))
或加入防空白判断,当Sheet1!$B3为空白时,公式也返回空白,以上公式返回的是#N/A错误值。
=IF(Sheet1!$B3,="","",LOOKUP(Sheet1!$B3,Sheet2!$A$8:$A$97,ROW($8:$97)))
公式的意思为:以Sheet1!$B3的值在Sheet2!$A$8:$A$97中查找最接近Sheet1!$B3的值且比它小的数值,找到后返回对应的8-97这个范围中的数字。
公式中的ROW($8:$97)要与单元格的实际总行数对应,如$A$8:$A$97共90行,那么ROW($8:$97)也是产生90个数字,这部份其实写作ROW($1:$90) EXCEL 也是不会提示出错的,只是结果返回的是1-90之间的数值。
=LOOKUP(Sheet1!$B3,Sheet2!$A$8:$A$97,ROW($8:$97))
或加入防空白判断,当Sheet1!$B3为空白时,公式也返回空白,以上公式返回的是#N/A错误值。
=IF(Sheet1!$B3,="","",LOOKUP(Sheet1!$B3,Sheet2!$A$8:$A$97,ROW($8:$97)))
公式的意思为:以Sheet1!$B3的值在Sheet2!$A$8:$A$97中查找最接近Sheet1!$B3的值且比它小的数值,找到后返回对应的8-97这个范围中的数字。
公式中的ROW($8:$97)要与单元格的实际总行数对应,如$A$8:$A$97共90行,那么ROW($8:$97)也是产生90个数字,这部份其实写作ROW($1:$90) EXCEL 也是不会提示出错的,只是结果返回的是1-90之间的数值。
看了 EXCEL公式内大括号里面的...的网友还看了以下:
解方程,把过程也写出来!56%x=﹙1-20%﹚-24154-2.7x=4.2x-2.5x6-0.6 2020-03-30 …
五年级数学上册同步学习解方程在线等x+5.8=14.224+x=39(检验)x-40=526x=3 2020-04-07 …
matlab多项式画图已知多项式为y=1.4017*10^(1/24)*x^10-8.0132*1 2020-05-16 …
(16.5-x)x2.8=14解方程 2020-06-13 …
(2012•莲都区模拟)(1)34x+18=12(2)X:8=14:134(3)85×0.75+4 2020-07-17 …
比如是3x+5x=48解:8x=48x=62x+8=16x/5=10x+7x=89x-3x=66x 2020-07-18 …
要方程2x+8=16x/5=10x+7x=89x-3x=66x-8=45x+x=9x-8=6x2x 2020-07-18 …
x/2-x+1/4=3t-t-2/4=57/3y+1=1/3(y-3)2x-1/3-=1+4x/5 2020-07-18 …
14分之9×2分之1×42=?13分之5×14+13分之8×14=?35÷(25分之8÷15分之8 2020-07-18 …
第一题:小超:能求出想x^2+6x-5的最小值吗?如果能,其最小值为多少?小强:能.因为x^2+6 2020-08-01 …