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

zhyoucheng

1. =TEXT(MONTH(A2)*10,"第[dbnum1]m季度")

复制代码

1. ="第"&MID("一二三四",MONTH(A2)/3+0.7,1)&"季度"

复制代码

孤单无所谓

1. =text(month(a2)/3+1,"第[dbnum1]d季度")

复制代码

hongqiqqq

1. ="第"&LOOKUP(MONTH(A2),{0,4,7,10},{"一","二","三","四"})&"季度"

复制代码

下拉即可

hsl215

公式：=LEN(2^MONTH(A2))
自定义格式：[DBNum1]"第"[$-804]G/通用格式"季度"

fffox

="第"&NUMBERSTRING(LEN(2^MONTH(A5)),1)&"季度"
=TEXT(LEN(2^MONTH(A2)),"第[dbnum1]0季度")

a595885232

=LOOKUP(MONTH(A11),{0,4,7,10},{"第一季度","第二季度","第三季度","第四季度"})
希望作对辣~

cleverzhzhf

1. =TEXT(CEILING(MONTH(A2)/3,1),"第[Dbnum1]0季度")

复制代码

hhxy

练习五

蓝粆

俺来啦~

1. ="第"&TEXT(INT(MONTH(A2)/3+0.7),"[DBNUM1]")&"季度"

复制代码

多发几条公式有没有奖励啊？

109888804

1. =TEXT(LEN(2^MONTH(A2)),"第[dbnum1]0季度")

复制代码