跪求這題有沒(méi)有簡(jiǎn)單的方法
=A2&"年第"&IF(B2>9,"四",IF(B2>6,"三",IF(B2>3,"二","一")))&"季度"
=A2&"年"&CHOOSE(ROUNDUP(MONTH(D2)/3,0),"第一季度","第二季度","第三季度","第四季度")