[算表] 將特定尾碼的數字取代成另一數字
軟體:office
版本:2013
有各種不同的數字
1762288
1723888
1678888
要如何將尾數是88,888,8888的數字
分別變成20,30,40呢
比如1678888->40
我只知道要打=if(mod(x,10000)=8888,20,0)
完整的公式該怎麼打呢
500p求救 謝謝T_T
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 110.54.168.80
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1506195444.A.4C1.html
推
09/24 07:11, , 1F
09/24 07:11, 1F
→
09/24 07:11, , 2F
09/24 07:11, 2F
→
09/24 07:11, , 3F
09/24 07:11, 3F
→
09/24 08:26, , 4F
09/24 08:26, 4F
→
09/24 08:27, , 5F
09/24 08:27, 5F
→
09/24 08:27, , 6F
09/24 08:27, 6F
→
09/24 08:46, , 7F
09/24 08:46, 7F
推
09/24 15:13, , 8F
09/24 15:13, 8F
→
09/24 15:14, , 9F
09/24 15:14, 9F
→
09/24 20:39, , 10F
09/24 20:39, 10F
→
09/24 20:40, , 11F
09/24 20:40, 11F
→
09/24 20:40, , 12F
09/24 20:40, 12F
→
09/24 20:42, , 13F
09/24 20:42, 13F
→
09/24 20:43, , 14F
09/24 20:43, 14F
→
09/24 20:44, , 15F
09/24 20:44, 15F
推
09/24 21:48, , 16F
09/24 21:48, 16F
→
09/24 21:49, , 17F
09/24 21:49, 17F
→
09/25 00:24, , 18F
09/25 00:24, 18F
→
09/25 00:24, , 19F
09/25 00:24, 19F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
