创建自己的Excel函数 体验强大功能(2)

图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