=C8*$C$5+D8*$D$5+E8*$E$5

=SUMPRODUCT(C8:E8,$C$5:$E$5)

=IF(B5>=90,"优秀",IF(B5>=80,"良","及格"))

=IF(条件,条件为真返回值,条件为假返回值)

=IF(AND(A4>=-5,A4<=5),"合格","不合格")

=IF(ABS(A4)<=5,"合格","不合格")

=VLOOKUP(A4,F:G,2,0)

=VLOOKUP(查找值,在哪个区域查找,返回区域第几列,精确或模糊匹配)

=VLOOKUP($A4,$E:$G,2,0)

=VLOOKUP($A4,$E:$G,3,0)

=VLOOKUP($A4,$E:$G,COLUMN(B1),0)

=A4&TEXT(B4,"!_yyyy-m-d")

=A4&TEXT(B4,"!_e-m-d")

=SUMIF(C:C,">30000", C:C)

=SUMIF(条件区域,条件,求和区域)

=SUMIF(A:A,"102*",C:C)

=COUNTIF(B:B,G5)

=COUNTIFS(B:B,G14,E:E,">20")

=COUNTIF(条件区域,条件)

=COUNTIFS(条件区域1,条件1,条件区域2,条件2……)

=IF(COUNTIF(A4,"*耳钉*"),"首饰","其他")

=IF(ISERROR(FIND("耳钉",A4)),"其他","首饰")

=IF(MOD(MID(A4,15,3),2),"男","女")

=IF(ISODD(MID(A2,15,3)),"男","女")

=--TEXT(MID(A4,7,8),"0-00-00")

=DATEDIF(D4,TODAY(),"y")

=A4&"-"&B4

=PHONETIC(A4:K4)

=VLOOKUP(G4,$A$3:$E$9,MATCH(H4,$A$3:$E$3,0),0)

=SUMPRODUCT(($A$4:$A$9=G4)*($B$3:$E$3=H4)*$B$4:$E$9)

=SUMIFS(C:C,A:A,E4,B:B,F4)

=LEFT(A4,LENB(A4)-LEN(A4))

=RIGHT(A4,2*LEN(A4)-LENB(A4))

=--LEFT(A4,FIND(" ",A4)-1)

=--RIGHT(A4,LEN(A4)-FIND(" ",A4))

=LEFT(A4,FIND(IF(ISNUMBER(FIND("区",A4)),"区","省"),A4))

=RIGHT(A4,LEN(A4)-LEN(B4))