Question

IF((O1=0)*(O2=0),"人民币"&NUMBERSTRING(N3,2)&"元整"，这是金额大小转换公式，负数金额怎么修改公式呢

Answer 1

公式：

=IF((O1=0)*(O2=0),"人民币"&IF(N3<0,"负","")&NUMBERSTRING(ABS(N3),2)&"元整")

追问

太感谢了，那如果后面有角分呢？

追答

对于有角和分的，公式要变得复杂：

=SUBSTITUTE(SUBSTITUTE(IF(-RMB(N3,2),TEXT(N3,";负")&TEXT(INT(ABS(N3)+0.5%),"[dbnum2]G/通用格式圆;;")&TEXT(RIGHT(RMB(N3,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(N3^2<1,,"零")),"零分","整")

Answer 2

改成:
IF((O1=0)*(O2=0),"人民币"&IF(N3<0,"负",)&TEXT(ABS(N3),"[dbnum2]")&"元整"