创建自己的Excel函数 体验强大功能(2)
发布时间:2021-06-08
发布时间:2021-06-08
图1添加自制函数说明
Function tax(income As Single) As Single
Select Case income
Case 0 To 800
tax = 0
Case 800.01 To 1300
tax = (income - 800) * 0.05
Case 1300.01 To 2800
tax = (income - 1300) * 0.1 + 25
Case 2800.01 To 5800
tax = (income - 2800) * 0.15 + 175
Case 5800.01 To 20800
下一篇:安全标准化绩效评定管理制度