xls表格数据处理: 我图上这里表格的A207这里有3个数字,且用逗号隔开...答:求和公式:=LEFT(SUBSTITUTE(A2,",",REPT(" ",99)),99)+MID(SUBSTITUTE(A2,",",REPT(" ",99)),100,99)+RIGHT(SUBSTITUTE(A2,",",REPT(" ",99)),99)注意里面的引号和空格是英文的,建议粘贴我的公式。示例:大小判断公式为:单双判断公式:...
小弟是做工程试验的,需要四舍六入五单双的修约方法,因此求个再excel中...答:两位小数:=IF(C2>(CEILING(C2,0.001)+FLOOR(C2,0.001))/2,CEILING(C2,0.001),IF(C2<(CEILING(C2,0.001)+FLOOR(C2,0.001))/2,FLOOR(C2,0.001),IF(MOD(RIGHT(TRUNC(C2,3),1),2)=0,TRUNC(C2,3),IF(TRUNC(C2,3)=C2,C2,TRUNC(C2,3)+0.001)))取二位小数时,把公式中的...