excel中,用公式,如下所述,请看看怎以做到?

日期:2011-03-03 15:14:42 人气:1

excel中,用公式,如下所述,请看看怎以做到?

D1公式 =IF(COUNTIF($A$1:$A$11,C1),VLOOKUP(C1,$A$1:$B$11,2,0),SLOPE(OFFSET(INDIRECT("b"&MATCH(C1,$A$1:$A$11)),,,2,),OFFSET(INDIRECT("a"&MATCH(C1,$A$1:$A$11)),,,2,))*C1+INTERCEPT(OFFSET(INDIRECT("b"&MATCH(C1,$A$1:$A$11)),,,2,),OF
    A+
热门评论