excel中,用公式,如下所述,请看看怎以做到?
excel中,用公式,如下所述,请看看怎以做到?
日期:2011-03-03 15:14:42 人气:1
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