EXCEL函数想返回一个单元格(
我试着给你一个通用公式,不限几位数的数值性单元格中返回某位数值的公式:
数值单元格为A1,在A2中显示某位数值,
个位数:
=IF(ISERROR(MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0)),1)),"",MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0)),1))十位数:
百位数:=IF(ISERROR(MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-1,1)),"",MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-1,1))
千位数:=I...全部
我试着给你一个通用公式,不限几位数的数值性单元格中返回某位数值的公式:
数值单元格为A1,在A2中显示某位数值,
个位数:
=IF(ISERROR(MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0)),1)),"",MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0)),1))十位数:
百位数:=IF(ISERROR(MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-1,1)),"",MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-1,1))
千位数:=IF(ISERROR(MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-2,1)),"",MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-2,1))
万位数:=IF(ISERROR(MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-3,1)),"",MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-3,1))
十万位数::=IF(ISERROR(MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-4,1)),"",MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-4,1))
百万位数::=IF(ISERROR(MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-5,1)),"",MID(ROUNDDOWN($A1,0),LEN(ROUNDDOWN($A1,0))-5,1))
以此类推:。
收起