[算表] Excel自訂函數的數值問題
軟體:
Excel
版本:
2007
下面是我的程式碼:
Function taxa(收入)
Dim index As Integer
index = 收入 / 20000 + 1
If 收入 > 80000 Then index = 5
taxa = 1 * Choose(index, 0.06, 0.06, 0.08, 0.11, 0.15)
End Function
1. 函數名是不是不能有數字啊?因為我一開始用tax1,不行用,後來我才改成taxa
2. Dim index as Integer這行有加和沒加跑出來的結果不一樣
可以請問為什麼嗎?我想不透。
收入 有Index as Integer 沒有Index as integer
28,500 0.06 0.06
47,200 0.08 0.08
78,600 0.15 0.11
24,580 0.06 0.06
36,170 0.08 0.06
個人猜想,有加那一行代表Index會四捨五入嗎?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.228.16.155
→
07/26 17:28, , 1F
07/26 17:28, 1F
→
07/26 17:55, , 2F
07/26 17:55, 2F
→
07/26 17:57, , 3F
07/26 17:57, 3F
→
07/26 18:01, , 4F
07/26 18:01, 4F
→
07/26 18:02, , 5F
07/26 18:02, 5F
→
07/26 18:04, , 6F
07/26 18:04, 6F
→
07/26 18:04, , 7F
07/26 18:04, 7F
→
07/26 19:45, , 8F
07/26 19:45, 8F
→
07/26 19:47, , 9F
07/26 19:47, 9F
→
07/26 19:59, , 10F
07/26 19:59, 10F
→
07/26 20:00, , 11F
07/26 20:00, 11F
→
07/26 20:10, , 12F
07/26 20:10, 12F
→
07/26 20:11, , 13F
07/26 20:11, 13F
→
07/26 20:13, , 14F
07/26 20:13, 14F
→
07/26 20:14, , 15F
07/26 20:14, 15F
→
07/26 20:17, , 16F
07/26 20:17, 16F
→
07/26 20:18, , 17F
07/26 20:18, 17F
→
07/26 20:30, , 18F
07/26 20:30, 18F
→
07/26 20:30, , 19F
07/26 20:30, 19F
→
07/27 00:31, , 20F
07/27 00:31, 20F