=LET(a,ISNUMBER(FIND(D13,$A$3:$A$10)),b,FILTER($I$3:$J$10,a),c,FILTER($K$3:$L$10,a),IF(C13<3,INDEX(FILTER($B$3:$H$10,a),MATCH(C13,$B$2:$H$2,1))*C13,IF(AND(C13>=3,C13<10),TAKE(b,,1)+TAKE(b,,-1)*(C13-1),TAKE(c,,1)+TAKE(c,,-1)*(C13-1))))
出现#calc! 计算逻辑错误
