如题所述
第1个回答 2011-08-31
贰拾贰万肆仟伍佰柒拾肆元壹分
假设224574.01在B20单元格,函数可以这样写=IF(B20<0,"无效数值",IF(B20=0,0,IF(INT(B20)=0,"",TEXT(INT(B20),"[dbnum2]")&"元")&IF(B20-INT(B20)=0,"整",IF(INT(B20*10)-(INT(B20)*10)=0,"",TEXT(INT((B20*10-INT(B20)*10)),"[dbnum2]")&"角"))&IF(INT((B20*100-INT(B20*10)*10))=0,"",TEXT(INT((B20*100-INT(B20*10)*10)),"[dbnum2]")&"分")))
假设224574.01在B20单元格,函数可以这样写=IF(B20<0,"无效数值",IF(B20=0,0,IF(INT(B20)=0,"",TEXT(INT(B20),"[dbnum2]")&"元")&IF(B20-INT(B20)=0,"整",IF(INT(B20*10)-(INT(B20)*10)=0,"",TEXT(INT((B20*10-INT(B20)*10)),"[dbnum2]")&"角"))&IF(INT((B20*100-INT(B20*10)*10))=0,"",TEXT(INT((B20*100-INT(B20*10)*10)),"[dbnum2]")&"分")))
第2个回答 2011-08-31
贰拾贰万肆仟伍佰柒拾肆圆零壹分本回答被提问者采纳
第3个回答 2011-08-31
贰拾贰万肆仟伍佰柒拾肆圆零壹分