|
<p>0574 补交作业</p><p>[hide]</p><p>1、a.数组:=B19*LOOKUP(B19+0.01,{1,1;100,1.1;200,1.2;300,1.4;500,1.6;700,1.8;1000,2;1500,2.2;2000,2.5})</p><p> b向量:=B26*LOOKUP(B26+0.01,{1,100,200,300,500,700,1000,1500,2000},{1,1.1,1.2,1.4,1.6,1.8,2,2.1,2.5})</p><p>2、=IF(ISERROR(LOOKUP(1,0/(TEXT(A3:A25,"m")&B3:B25=F3&F4),C3:C25))=TRUE,0,LOOKUP(1,0/(TEXT(A3:A25,"m")&B3:B25=F3&F4),C3:C25))</p><p>3、=VLOOKUP(LOOKUP(1,0/((OFFSET($C$5:$C$26,,MATCH($H$4,$C$4:$E$4,0)-1))=(LARGE((OFFSET($C$5:$C$26,,MATCH($H$4,$C$4:$E$4,0)-1)),ROW()-6))*(COUNTIF(G$6:$G6,$A$5:$A$26)=0)),$A$5:$A$26),IF({1,1,0},$A$5:$B$26,OFFSET($C$5:$C$26,,MATCH($H$4,$C$4:$E$4,0)-1)),COLUMN()-6,0)</p> |
|