函初【201401】练习题五--已开贴

xwp2010

=IF(ROUNDUP(MONTH(A2)/3,0)=1,"第一季度",IF(ROUNDUP(MONTH(A2)/3,0)=2,"第二季度",IF(ROUNDUP(MONTH(A2)/3,0)=3,"第三季度",IF(ROUNDUP(MONTH(A2)/3,0)=4,"第四季度",))))

=LOOKUP(INT((month(A1)-1)/3)+1,{1,"第一季度";2,"第二季度";3,"第三季度";4,"第四季度"})

="第"&TEXT(INT((MONTH(A2)-1)/3)+1,"[dbnum1]")&"季度"

air05

在D列与E列构建辅助列在C2输入公式=VLOOKUP(MONTH(A2),$D$2:$E$5,2,1)后下拉公式

liziyuliziyu7

="第"&NUMBERSTRING(MONTH(MONTH(A2)&0),1)&"季度"

="第"&NUMBERSTRING(LEN(2^MONTH(A2)),1)&"季度"

红旗雪

又学习了