excel,分别截取一数值,万,百…角分位答:千万位:=IFERROR(IF(LEN(INT(P7))=7,"¥",MID(INT(P7),LEN(INT(P7))-7,1)),"")百万位:=IFERROR(IF(LEN(INT(P7))=6,"¥",MID(INT(P7),LEN(INT(P7))-6,1)),"")十万位:=IFERROR(IF(LEN(INT(P7))=5,"¥",MID(INT(P7),LEN(INT(P7))-5,1)),"")万位:=IF...
在excel 2003 里如何把一个数值分别填到金额的个十百千万答:十位=IF(C1=5,IF(INT(A1)<>0,"¥",""),IF(C1>5,LEFT(RIGHTB($B1,5),1),""))百位=IF(C1=6,"¥",IF(C1>6,LEFT(RIGHTB($B1,6),1),""))千位=IF(C1=7,"¥",IF(C1>7,LEFT(RIGHTB($B1,8),1),""))万位=IF(C1=9,"¥",IF(C1>8,LEFT(RIGHTB($B1,9),1),"...