=((MID(ROUND(A1*10000,0),LEN(ROUND(A1*10000,0)),1)*1=5)*(MOD(MID(ROUND(A1*10000,0),LEN(ROUND(A1*10000,0))-1,1),2)*1=1)*1+MID(ROUND(A1*10000,0),1,LEN(ROUND(A1*10000,0))-1))/1000
搞了一小时.
=((MID(ROUND(A1*10000,0),LEN(ROUND(A1*10000,0)),1)*1=5)*(MOD(MID(ROUND(A1*10000,0),LEN(ROUND(A1*10000,0))-1,1),2)*1=1)*1+MID(ROUND(A1*10000,0),1,LEN(ROUND(A1*10000,0))-1))/1000
搞了一小时.