Excel.EXE里输入数字如何转换成大写并加上人民币?
时间:2023-11-03 21:05:04
如果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]")&"分","整")))”
标签:Excel.EXE里输入数字如何转换成大写并加上人民币?
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
如何在Win10上禁用PowerShell?Win10禁用PowerShell教程
2022-10-03 00:16:36
![](https://img.aspxhome.com/file/2023/25/a218670_0s.jpg)
把PowerPoint课件转换成SWF格式
2023-04-03 21:34:40
雨课堂的课件怎么导出_雨课堂的课件导出教程
2022-03-28 08:29:54
![](https://img.aspxhome.com/file/2023/3/a295148_0s.jpg)
猪年主题包怎么样?微软Win10猪年主题包发布(附下载地址)
2023-05-09 18:56:44
![](https://img.aspxhome.com/file/2023/28/a241421_0s.jpg)
excel公式如何强制返回数组
2022-11-18 03:08:03
![](https://img.aspxhome.com/file/2023/6/a142746_0s.jpg)
Microsoft Excel 教程「34」,如何在 Excel 中使用 SUMIFS 函数?
2022-08-31 06:38:02
![](https://img.aspxhome.com/file/2023/3/a202753_0s.jpeg)
在WORD2003怎么使图片相对于页边距下侧1cm?
2023-11-30 05:48:39
![](https://img.aspxhome.com/file/2023/7/18927_0s.jpg)
wps表格保护怎么去掉?
2023-08-20 14:44:38
![](https://img.aspxhome.com/file/2023/5/a168925_0s.png)
神剪辑怎么加音频?神剪辑加音频的方法
2023-09-09 06:35:53
![](https://img.aspxhome.com/file/2023/8/a334684_0s.jpg)
为*.doc格式的保存操作设计一个快捷键快速保存doc格式
2023-06-03 18:26:40
![](https://img.aspxhome.com/file/2023/2/29252_0s.jpg)
word怎么在箭头上显示一些文字?
2022-05-11 02:16:00
![](https://img.aspxhome.com/file/2023/1/23191_0s.png)
win8分区C盘要多大 Win8系统C盘多大合适
2023-04-10 01:20:16
![](https://img.aspxhome.com/file/2023/29/a255462_0s.jpg)
微信如何“长截图”?微信“长截图”教程
2022-03-16 01:14:36
![](https://img.aspxhome.com/file/2023/1/a200141_0s.jpg)
如何使用super photocu抠图工具在图像中剪出婚纱礼服和面纱?
2023-04-05 10:07:15
![](https://img.aspxhome.com/file/2023/3/a213823_0s.jpeg)
ppt图片链接接怎么设置打开方式是图片查看器?
2022-08-09 11:40:01
![](https://img.aspxhome.com/file/2023/10/a347243_0s.jpg)
PPT图片排版的3个技巧,教你如何提高层次感?
2022-06-25 11:47:05
![](https://img.aspxhome.com/file/2023/10/a352828_0s.jpg)
Win7如何屏蔽U盘禁用USB设备
2022-07-13 19:59:04
![](https://img.aspxhome.com/file/2023/29/a252250_0s.jpg)
win2008远程桌面连接winxp连接不上的解决方法
2023-05-02 14:36:31
Win11如何创建新用户?Win11创建新用户的方法
2023-06-22 02:11:33
![](https://img.aspxhome.com/file/2023/27/a236440_0s.jpg)
Win10通过Compact压缩技术节省硬盘空间的方法
2022-12-31 19:10:15
![](https://img.aspxhome.com/file/2023/26/a226533_0s.jpg)