[算表] 去掉符號後相加減
軟體:excel
版本:2013
我的數據都是數字前面有正負號
可是+ -號後卻有空格
譬如+ 10 這樣顯示出來就不是10而是文字[+]和數字[10]
如此就沒辦法運算了
我用SUBSTITUTE 取出數字 可是依然沒辦法做運算
譬如 =SUBSTITUTE(SUBSTITUTE(A1,"+",""),"-","")
我把上面整個加上括號
=(SUBSTITUTE(SUBSTITUTE(A1,"+",""),"-",""))
-(SUBSTITUTE(SUBSTITUTE(B1,"+",""),"-",""))
也是不行
請問各位板友這種情況能解決嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.227.224.134
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1430922887.A.506.html
→
05/06 22:37, , 1F
05/06 22:37, 1F
→
05/06 22:40, , 2F
05/06 22:40, 2F
→
05/06 23:16, , 3F
05/06 23:16, 3F
→
05/06 23:18, , 4F
05/06 23:18, 4F
→
05/06 23:18, , 5F
05/06 23:18, 5F
→
05/06 23:20, , 6F
05/06 23:20, 6F
→
05/07 00:45, , 7F
05/07 00:45, 7F
→
05/07 07:06, , 8F
05/07 07:06, 8F
→
05/07 07:07, , 9F
05/07 07:07, 9F
Office 近期熱門文章
PTT數位生活區 即時熱門文章