K3=VLOOKUP(I3,A:G,LOOKUP(1,0/(J3-LEFT(B$2:G$2,2)>=0),COLUMN(B:G)),)+(J3-LEFT(INDEX($2:$2,LOOKUP(1,0/(J3-LEFT(B$2:G$2,2)>=0),COLUMN(B:G))),2))*INDEX(C$3:G$6-B$3:F$6,MATCH(I3,A:A,)-2,LOOKUP(1,0/(J3-LEFT(B$2:G$2,2)>=0),COLUMN(A:F)))/INDEX(LEFT(C$2:G$2,2)-LEFT(B$2:F$2,2),LOOKUP(1,0/(J3-LEFT(B$2:G$2,2)>=0),COLUMN(A:F)))
留言
張貼留言