excel 大小写

Question

=IF(ROUND(O8,2)=0,"",IF(O8<0,"负","")&IF(ABS(O8)>=1,TEXT(INT(ROUND(ABS(O8),2)),"[dbnum2]")&"元","")&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(O8,2),2),"[dbnum2]0角0分;;整"),"零角",IF(O8^2<1,,"零")),"零分",""))，以上是这个，我想问一下0元的时候为何显示空白的，不显示零元？我现在想在这个基础上，显示零元整，不是空白！

Answer 1

=IF(O8<0,"负","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(O8)),"[dbnum2]")&"元"&TEXT(RIGHT(INT(ABS(O8*100)),2),"[dbnum2]0角0分")&"整","零角零分",""),"零分",""),"分整","分")
复制粘贴这个公式