MrExcel Publishing
Your One Stop for Excel Tips & Solutions

function not functioning


Posted by dr jay on January 04, 2002 9:39 AM

i am creating a function to calculate a tax value based off of income. However once the variable does not meet the first value condition i get a #value! error in excel. What is wrong with the below code:

Function tax(tax_income)
select case tax_income
case is < 20000
tax = tax_income * .015
case is 20000 to 100000
tax = tax_income * .037
case else tax = 0
end case
end function


Posted by Russell Hauf on January 04, 2002 9:44 AM

Try this (hope it helps):

Function tax(tax_income)
Select Case tax_income
Case Is < 20000
tax = tax_income * 0.015
Case 20000 To 100000
tax = tax_income * 0.037
Case Else
tax = 0
End Select
End Function


value based off of income. However once the variable does not meet the first value condition i get a #value! error in excel. What is wrong with the below code: