正负符号能转换成范围数值吗?如在excel中2±1怎样快速转换成1~3的...答:如图所示,在 D3 单元格输入公式:=SUMPRODUCT({1,-1}*MID(SUBSTITUTE(B3,"±",REPT(" ",10)),{1,10},10))&"~"&SUMPRODUCT({1,1}*MID(SUBSTITUTE(B3,"±",REPT(" ",10)),{1,10},10))复制并下拉,即可………高版本的EXCEL可以改用公式:=EVALUATE(SUBSTITUTE(B3,"±","-"))...