1、B1公式=IF(A1<12,A1&"个月",IF(MOD(A1,12)=0,A1/12&"年",ROUNDDOWN(A1/12,0)&"年"&MOD(A1,12)&"个月")),在A1输入月数,如果小于12个月,显示多少个月;如果被12整除,B1显示多少年;否则,B1显示多少年多少月。
2、如果A1输入带单位的数据,比如“73个月”,上面公式改为:
=IF(--SUBSTITUTE(A2,"个月","")<12,A2,"")&"个月",IF(MOD(SUBSTITUTE(A2,"个月",""),12)=0,SUBSTITUTE(A2,"个月","")/12&"年",ROUNDDOWN(SUBSTITUTE(A2,"个月","")/12,0)&"年"&MOD(SUBSTITUTE(A2,"个月",""),12)&"个月"))
温馨提示:答案为网友推荐,仅供参考