请教有关人民币小写转换成大写格式公式的讲解
一片粉嫩的羽毛
2024-05-16 12:44:31
最佳回答
设a1列为数据列,则在a2输入以下公式(可复制): =if(a1<0,"负","")&if(abs(a1)>1,text(trunc(abs(round(a1,2))),"[dbnum2]")&"元","")&if(**err(find(".",round(a1,2))),"",text(right(trunc(round(a1,2)*10)),"[dbnum2]"))&if(**err(find(".0",text(a1,"0.00"))),"角","")&if(left(right(round(a1,2),3))=".",text(right(round(a1,2)),"[dbnum2]")&"分","整") 20210311