EXCEl内插法求值问题答:问题一.在E2输入公式:=ROUND(TREND(OFFSET(B$1368,MATCH(D1369,A$1369:A$1378),,2),OFFSET(A$1368,MATCH(D1369,A$1369:A$1378),,2),D1369),2)问题二.在H2输入公式:=ROUND(TREND(OFFSET(A$1368,MATCH(G1369,B$1369:B$1378),,2),OFFSET(B$1368,MATCH(G1369,B$1369:B$1378),,2...
Excel中判断右边的全部字段字符,包含在左边里答:I3输入 =IF(ISERR(FIND(H3,F3)),"","包含")回车并向下填充。你的赏分不少,再给你几道公式吧:之前的叫”反推法“。还有:=IF(COUNT(FIND(H3,F3)),"包含","")——”计数法“=IF(ISERR(SEARCH(H3,F3)),"","包含")——”反推法“=IF(COUNTIF(F3,"*"&H3&"*"),"包含","")—...