Excel.EXE里输入数字如何转换成大写并加上人民币?

如果B1单元格是数字，则在C1单元格输入“=\"人民币：\"&IF(TRIM(B1)=\"\",\"\",IF(B1=0,\"\",\"人民币\"&IF(B1<0,\"负\",)&IF(INT(B1),TEXT(INT(ABS(B1)),\"[dbnum2]\")&\"元\",)&IF(INT(ABS(B1)*10)-INT(ABS(B1))*10,TEXT(INT(ABS(B1)*10)-INT(ABS(B1))*10,\"[dbnum2]\")&\"角\",IF(INT(ABS(B1))=ABS(B1),,IF(ABS(B1)<0.1,,\"零\")))&IF(ROUND(ABS(B1)*100-INT(ABS(B1)*10)*10,),TEXT(ROUND(ABS(B1)*100-INT(ABS(B1)*10)*10,),\"[dbnum2]\")&\"分\",\"整\")))”