Excel如何用函数进行数字区间的对比,返回指定值?答:区间数字不固定时 B2=IF(AND(C2>=--LEFT(TRIM(MID(SUBSTITUTE($A2,"-",REPT(" ",99)),COLUMN(A2)*99-98,99)),2),C2<=--LEFT(TRIM(MID(SUBSTITUTE($A2,"-",REPT(" ",99)),COLUMN(B2)*99-98,99)),2)),0,IF(C2<--LEFT(TRIM(MID(SUBSTITUTE($A2,"-",REPT(" ",99)),...
excel设置公式,单元格包含某个值,返回结果?答:思路:用多层IF进行嵌套来判断。用FIND来查找。FIND找到则返回数字,否则是错误值 #VALUE!。 那么外层用ISNUMBER来判断是不是数字,如果是表明找到,否则没有找到。公式如下:=IF(ISNUMBER(FIND("客",B1)),"客服连线",IF(ISNUMBER(FIND("维",B1)),"装维售后",IF(ISNUMBER(FIND("渠道",B1)),"...
excel表中如何用函数实现多重条件查找并返回指定值答:依照你举例的单元格位置,复制下面的公式到Sheet2!C1 =INDEX(Sheet1!E$1:E$5,MAX(IFERROR(MATCH(A1&B1,Sheet1!A$1:A$5&Sheet1!B$1:B$5,0),-1),IFERROR(MATCH(A1&B1,Sheet1!A$1:A$5&Sheet1!C$1:C$5,0),-1),IFERROR(MATCH(A1&B1,Sheet1!A$1:A$5&Sheet1!D$1:D$5,...