怎么才能把在单元格里1000.56转换成人民币中文大写“壹仟元伍角陆分正”

问题：怎么才能把在单元格里1000.56转换成人民币中文大写“壹仟元伍角陆分正”

已知：H6=1000.50  (其中:H6改成你对应的小写单元格)。

函数：=IF(H6<0.005,"",IF(H6<0,"负",)&IF(INT(ABS(H6)),TEXT(INT(ABS(H6)),"[dbnum2]")&"元",)&IF(INT(ABS(H6)*10)-INT(ABS(H6))*10,TEXT(INT(ABS(H6)*10)-INT(ABS(H6))*10,"[dbnum2]")&"角",IF(INT(ABS(H6))=ABS(H6),,IF(ABS(H6)<0.1,,"零")))&IF(ROUND(ABS(H6)*100-INT(ABS(H6)*10)*10,),TEXT(ROUND(ABS(H6)*100-INT(ABS(H6)*10)*10,),"[dbnum2]")&"分","整"))

结果：壹仟元伍角陆分