Excel笔记

发表于 2022年09月02日 · 归类于技术 · 阅读完需 1 分钟 ·

一、基础部分

=sum()

=avg()

=count()

=LEFT(B34,1)

=CONCATENATE("张三","李四") #张三李四

=MID(A6,7,8) #522228199907201735->19990720

=IF(MOD(MID(A6,17,1),2),"男","女") #522228199907201735->男

=DATEDIF(TEXT(MID(E2,7,8),"#-00-00"),TODAY(),"y") #522228199907201735->23

=(A1+8*3600)/86400+70*365+19

yyyy"年"mm"月"dd"日"hh"时"mm"分"ss"秒"

=IF(MOD(ROW()+1,2)=1,CONCATENATE(ROW()/2,"组：",B2,A2,";",B3,A3),"")