Want IF Statement to compute Tax formulas

Eninla

New member
Joined
Jun 22, 2012
Messages
2
Reaction score
0
Points
0
I am currently working on Payroll that would calculate Housing Allowance, transport and others.. but I have problem with building UDF for Tax where the following condition will apply Between 50000 to 74999 should have tax of 10% of basic salary, Between 75,000 to 89,999 should be taxed 20% of Basic salary, between basic salary of 90,000 to 10,000 should be taxed 22% * basic salary ---- I want to define a Function which will be =Tax() to calculate using the parameters above. Please help I am new to VBA. I have defined functions for Housing as Function Housing(a), Housing = a* 34/100, End Function.... so also for transport and other - but the Tax will involve logical If and I don't know what to do next... thanks Please I need answer urgently. thanks and God bless u.
 

tommyt61

New member
Joined
Mar 26, 2011
Messages
153
Reaction score
0
Points
0
See if this works ... i may not understood correctly what you need , but won't hurt to try. Of course you will need to change cell d16 to match your situation.

Code:
=IF(AND(D16>=50000,D16<75000),D16*0.1,IF(AND(D16>=75000,D16<90000),D16*0.2,IF(AND(D16>=90000,D16<100001),D16*0.22,)))
 

Eninla

New member
Joined
Jun 22, 2012
Messages
2
Reaction score
0
Points
0
Re: Tax Computation

See if this works ... i may not understood correctly what you need , but won't hurt to try. Of course you will need to change cell d16 to match your situation.

Code:
=IF(AND(D16>=50000,D16<75000),D16*0.1,IF(AND(D16>=75000,D16<90000),D16*0.2,IF(AND(D16>=90000,D16<100001),D16*0.22,)))


Thanks a lot for your prompt response, but what i really need is to create a user defined function to handle the function above -- so that when I enter something like =Tax(a1, c2) it will calculate using the UDF name and the logical operation created above inclusive.

So may be something like:

Function Tax(a, b)

If a >= 50000 Then
b = 10/100 * a
Elseif a>= 75000 Then
b = 12.5/100 * a
End If

Where a (maybe) will hold the basic salary.
 

aj203akash

New member
Joined
Dec 6, 2013
Messages
3
Reaction score
0
Points
0
salary income tax formula

Hi, Dear

Please give me the salary income tax formula i am from Gujarat

Please send me the formula so, that i can put that formula in excel sheet and calculate the tax

I am attached here the tax slab for your reference


 

Attachments

  • Tax Slab.docx
    12.2 KB · Views: 36
Top