=IF(LEFT(A1)="-",SUBSTITUTE(SUBSTITUTE(TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","
在EX表格中怎么做公式才能把前面一个表格的负值数字变成大写的圆角分的数值,但是不显示负字. -415,985.64 = 肆拾壹万伍仟玖佰捌拾伍元陆角肆分 例如这样 答案 =IF(LEFT(A1)="-",SUBSTITUTE(SUBSTITUTE(TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0...