Need help on complex IF function

I'm trying to create a function that determines the appropriate federal tax rate based on the company's earnings before taxes.

To illustrate, I'm trying to write a function that basically says "if(Earnings for year 1 are either greater than or equal to zero and less than $50k, then the tax rate is 15%, otherwise if(earnings for year 1 are either greater than or equal to $50k and less than $75k, then taxes are $7,500, otherwise if(earnings for year 1 are either greater than or equal to $75K and less than $100k, then taxes are $13750, and on so on...

Any help would be much appreciated

Please Login or Register  to view this content.

Ok so here's what I did:

Cell B12 on my spread sheet I renamed to "earnings" since that is the income number. Below is the code (please keep in mind I'm am absolute amateur at VBA). When I try to run the function the only number getting returned is 0. Not sure where I'm going wrong.

Function Calc_Tax(earnings) As Double
Select Case earnings
Case Is < 50000
Calc_Tax = 15
Case Is >= 50000 < 75000
Calc_Tax = 7500
Case Is >= 75000 < 100000
Calc_Tax = 13750
Case Is >= 100000 < 335000
Calc_Tax = 22250
Case Is >= 335000 < 10000000
Calc_Tax = 113900
Case Is >= 10000000 < 15000000
Calc_Tax = 3400000
Case Is >= 15000000 < 18333333
Calc_Tax = 5150000
Case Is >= 18333333
Calc_Tax = 35
End Select
End Function

Originally Posted by boopathiraja

hi, tRY THE BELOW formula

Formula:

Please Login or Register  to view this content.

Thank you, this works.