Excel表格中如何实现B列满足文本条件后,输出A列文本内容,且输出内容不...答:F2=INDEX(A:A,SMALL(IF(MATCH($A$3:$A$100&$B$3:$B$100&"",$A$3:$A$100&$B$3:$B$100&"",)*($B$3:$B$100="借款")=ROW($A$3:$A$100)-2,ROW($A$3:$A$100),65536),ROW(A1)))&""G2=INDEX(C:C,SMALL(IF(MATCH($A$3:$A$100&$B$3:$B$100&"",$A$3:...
Excel在空白单元格符合多个条件后显示指定文本数据?答:在 Excel 2007 中,可以用以下公式满足题述要求:1. 非数组公式:=IF(B2>110,IF(D2<=9%,"不置休",IF(AND(D2>9%,D2<=18%),"2小时",IF(AND(D2>18%,D2<=30%),"4小时",IF(AND(D2>30%,D2<=100%),"6小时",""))),IF(C2<=7,"不置休",IF(AND(C2>7,C2<=12),"2小...