=TEXT(TRUNC(C11),"[dbnum2]")&"元"&IF(TRUNC(C11*100)-TRUNC(C11)*100=0,"整",IF(TRUNC(C11*100)-TRUNC(C11*10)*10=0,TEXT(TRUNC(C11*10)-(TRUNC(C11)*10),"[dbnum2]")&"角整",IF(TRUNC(C11*10)-(TRUNC(C11)*10)=0,"零角"&TEXT(TRUNC(C11*100)-(TRUNC(C11*10)*10),"[dbnum2]")&"分",TEXT(TRUNC(C11*10)-(TRUNC(C11)*10),"[dbnum2]")&"角"&TEXT(TRUNC(C11*100)-(TRUNC(C11*10)*10),"[dbnum2]")&"分")))
其中C11*100代表11行C列,