1024.06 仟佰拾元角分 请在EXCEL里加上六个公式,能自动显示出 '壹...答:仟:=TEXT(MID(A1,1,1),"[dbnum2]0")佰:=TEXT(MID(A1,2,1),"[dbnum2]0")拾:=TEXT(MID(A1,3,1),"[dbnum2]0")元:=TEXT(MID(A1,4,1),"[dbnum2]0")角:=TEXT(MID(A1,6,1),"[dbnum2]0")分:=TEXT(MID(A1,7,1),"[dbnum2]0")...
Excel电子表格函数公式后面如何添加单位请教高手答:假设数字在a1,则 结果=IF(OR(A1="",A1=0),"",TEXT(INT(A1),"[dbnum2]")&IF(INT(A1)=A1,"元整","元")&IF(AND(INT(A1)<>A1,--RIGHT(INT(A1*10))=0),"零",TEXT(--RIGHT(INT(A1*10)),"[dbnum2]#角;;;"))&TEXT(--RIGHT(INT(A1*100))...
excel元角分十进制计算公式(答非所问的请勿进)答:思路:利用一个辅助行先把数字提取出来,合计,再进行转换。所有公式集合在B1单元格后公式太长,分段进行。A2=LEFT(A1,FIND("拾",A1)-1)*10+IF(MID(A1,FIND("拾",A1)+1,FIND("元",A1)-1-FIND("拾",A1))="",0,MID(A1,FIND("拾",A1)+1,FIND("元",A1)-1-FIND("拾",A1)))...