TA的每日心情 | 开心 2023-11-28 10:15 |
---|
签到天数: 85 天 [LV.6]常住居民II
|
‘=IF(ISNUMBER($N$49),IF($N$49<0,"无效数值",IF($N$49<0.005,"零",IF($N$49<0.995,"",TEXT(INT($N$49+0.005),"[dbnum2]")&"元")&IF(LEFT(RIGHT(FIXED($N$49,2),2),1)="0",IF(RIGHT(FIXED($N$49,2),1)="0","",IF($N$49>0.995,"零","")),TEXT(LEFT(RIGHT(FIXED($N$49,2),2),1),"[dbnum2]")&"角")&IF(RIGHT(FIXED($N$49,2),1)="0","整",TEXT(RIGHT(FIXED($N$49,2),1),"[dbnum2]")&"分"))),"非数值!")
大小写在财务工作中经常要用到,希望能给大家带来帮助 |
|