视频:Excel单元格中实现金额的大写
时间:2022-06-21 10:08:09
4、在Excel单元格中实现金额的大写:(假设对A1中的数字进行转换)=IF(ROUND(A1,2)<0,"无效数值",IF(ROUND(A1,2)=0,"零",IF(ROUND(A1,2)<1,"",TEXT(INT(ROUND(A1,2)),"[dbnum2]")&"元")&IF(INT(ROUN4、在Excel单元格中实现金额的大写:
(假设对A1中的数字进行转换)=IF(ROUND(A1,2)<0,"无效数值",IF(ROUND(A1,2)=0,"零",IF(ROUND(A1,2)<1,"",TEXT(INT(ROUND(A1,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10=0,IF(INT(ROUND(A1,2))*(INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10)=0,"整",TEXT((INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10),"[dbnum2]")&"分")))
标签:金额,实现,单元,视频,",A1,ROUND,INT,IF,&,-INT
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
Win10系统屏幕一闪一闪的黑屏怎么办?
2023-11-23 13:33:18
![](https://img.aspxhome.com/file/2023/2/50232_0s.png)
如何使用excel中的查找和替换功能拆分与数字混合的文本字符串
2022-03-05 07:39:06
![](https://img.aspxhome.com/file/2023/9/a140809_0s.gif)
Word文档忘记保存怎么办
2023-11-09 20:26:28
![](https://img.aspxhome.com/file/2023/8/17188_0s.jpeg)
word如何创建模板
2023-11-14 09:30:42
WPS如何修改Word文档作者?
2023-08-25 08:33:12
![](https://img.aspxhome.com/file/2023/0/31420_0s.png)
删除或修改的上方和下方已筛选的Excel 2007中隐藏的行的行也将删除或修改隐藏的行
2022-11-18 21:56:13
![](https://img.aspxhome.com/file/2023/9/38429_0s.jpg)
Word2003是如何运行宏的?
2023-12-13 14:42:55
Excel 如何设置单元格默认格式变成日期?
2022-02-09 07:41:09
Word怎么编辑已经做好的Excel图表?
2022-08-08 15:11:18
![](https://img.aspxhome.com/file/2023/9/28849_0s.jpg)
怎么让word表格里的文字居中显示呢?
2023-12-10 01:01:41
![](https://img.aspxhome.com/file/2023/6/20436_0s.jpg)
win10系统日志在哪里查看?具体要怎么查看?
2023-09-02 06:47:40
![](https://img.aspxhome.com/file/2023/0/47180_0s.jpg)
excel怎么求和?Excel的求和多种方法
2023-05-10 07:20:35
![](https://img.aspxhome.com/file/2023/1/41641_0s.jpg)
怎样解决Excel套用表格样式后不能合并
2022-12-12 20:29:16
![](https://img.aspxhome.com/file/2023/9/38099_0s.png)
Win10任务栏如何透明化?Win10任务栏设置透明化的方法
2023-11-17 08:59:18
![](https://img.aspxhome.com/file/2023/8/48908_0s.jpg)
Word2007 日历模板的使用技巧
2022-11-10 12:38:14
word怎么删除空白段落?
2023-04-07 21:39:20
![](https://img.aspxhome.com/file/2023/5/34745_0s.gif)
win10如何设置系统还原点?win10设置系统还原点的方法
2023-10-29 00:11:12
![](https://img.aspxhome.com/file/2023/6/47716_0s.png)
iPadOS 15 小技巧:“快速备忘录”使用方法详解
2023-08-20 05:40:10
![](https://img.aspxhome.com/file/2023/1/45751_0s.png)
Word2013怎样把文字倒过来显示?
2023-12-10 13:50:22
![](https://img.aspxhome.com/file/2023/7/20637_0s.jpg)
怎么设置Excel中单元格连续相乘?
2022-05-01 15:40:31
![](https://img.aspxhome.com/file/2023/4/39944_0s.jpg)