excel练习

=DATEDIF(TODAY(),DATE(2019,11,11),"D")
间隔天数

=EOMONTH(TODAY(),0)
获取月底日期

=TEXT(DATE(2019,11,11),"yyyy")
提取年月日

=AVERAGEIF(B2:B10,"语文",C2:C10)
计算语文平均分

=SUMIFS(C2:C10,A2:A10,"孙")-SUMIFS(C2:C10,A2:A10,"孙",B2:B10,"英语")
计算孙同学英语成绩以外的总分

=COUNTIFS(B2:B10,"语文",C2:C10,">87")+1
计算孙同学的语文成绩排名

A真，1，A假B真，2，否则，-2
=IF(A,1,IF(B,2,-2))

=VLOOKUP("xm100001",IF({1,0},C2:C6,A2:A6),2,0)
逆向透视