Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Excel formula for calculating slabs

CA.Sonia (professional) (517 Points)

03 April 2013

Hi ,

Can any body provide the excel sheet of formula to be used for calculating the income tax slabs for different Incomes.

Thanks

Reply
Follow
Share

38 Replies

Vaibhav Jandey (Life iz Hard; I'm Harder) (1175 Points)
Replied 03 April 2013

Originally posted by : CA.Sonia
	Hi , Can any body provide the excel sheet of formula to be used for calculating the income tax slabs for different Incomes. Thanks

Here is it

=IF(D952<200000,0,IF(D952<500000,(D952-200000)*0.1,IF(D952<1000000,(D952-500000)*0.2+30000,IF(D952>1000000,(D952-1000000)*0.3+130000,))))

Replace the extreme left figure in above formula with the exemption limit of other person(s).

6 Like

Upgrade to CAclubindia Pro. Subscribe Now!

Vivek B. Bhinde (Action Creates Energy !!) (824 Points)
Replied 03 April 2013

The Income Tax Calculator is hereby attached....

Attached File : 1021728 1158990 income tax calculator ay 2013 14.xls downloaded: 11899 times

Vivek B. Bhinde (Action Creates Energy !!) (824 Points)
Replied 03 April 2013

In the above attachment there is a minor formula error, Please use the hereby attached file...

Attached File : 1021728 1159045 income tax calculator ay 2013 14.xls downloaded: 6793 times

Swapnil (student) (23 Points)
Replied 26 December 2013

It is not working, if a person having income of Rs Rs. 10,00,000. Kindly copy Properly

Swapnil (student) (23 Points)
Replied 26 December 2013

Cheat This One =IF(H6<220000,0,IF(H6<500000,(H6-220000)*0.1,IF(H6<1000000,(H6-500000)*0.2+28000,IF(H6=1000000,(H6-500000)*0.2+28000,IF(H6>1000000,(H6-1000000)*0.3+128000,)))))

Upgrade to CAclubindia Pro. Subscribe Now!

amit kumar (ASSISTANT ACCOUNTANT) (22 Points)
Replied 23 June 2015

income tax calculator if excel formula

=IF(AND(A4>0;A4<=250000);"not tax";IF(AND(A4>250001;A4<=500000);(A4-250000)*10/100;IF(AND(A4>500001;A4<=1000000);(A4-500000)*20/100+25000;IF(AND(A4>1000000);(A4-1000000)*30/100+125000))))

Rekha (MBA) (21 Points)
Replied 24 June 2015

thanks Amit....

Rakib (Finance Professional) (30 Points)
Replied 17 August 2015

Please help me to calculate tax in excel

First 250000 0%
Next 400000 10%
Next 500000 15%
Next 600000 20%
Next 3000000 25%
4750000 30% if total amount is above forty sevel lac fifty thousand then 30% tax on rest of the amount

Regards

Rakib

Kiran. S (CTO) (745 Points)
Replied 17 August 2015

@ amit kumar Logical operators "and" and "if" take comma "," instead of semicolon ";"

Thanks.

S. Shiroor (Others) (1207 Points)
Replied 17 August 2015

Goto Developer -Visual basic- tools - references - tick visual basic for apllications [VBA] then

insert module.

Paste following code in module

Function Tax2015(Inco)
Select Case Inco
Case Is < 250000
Tax2015 = 0
Case Is <= 500000
Tax2015 = (Inco - 250000) * 0.1
Case Is <= 1000000
Tax2015 = 25000 + (Inco - 500000) * 0.2
Case Is > 1000000
Tax2015 = 125000 + (Inco - 1000000) * 0.3
Case Else

End Select

End Function

any where you can type =Tax2015 (A5) a5 is cel where taxabale income is there

I hope this helpsl

Upgrade to CAclubindia Pro. Subscribe Now!

Rakib (Finance Professional) (30 Points)
Replied 18 August 2015

I posted a problem and got a solution through email. But it doesn't work.

Problem was:

Please help me to calculate tax in excel First 250000 0% Next 400000 10% Next 500000 15% Next 600000 20% Next 3000000 25% 4750000 30% if total amount is above forty sevel lac fifty thousand then 30% tax on rest of the amount

and solution was:

excel-formula-for-calculating-slabs

Goto Developer -Visual basic- tools - references - tick visual basic for apllications [VBA] then

insert module.

Paste following code in module

any where you can type =Tax2015 (A5) a5 is cel where taxabale income is there

I hope this helpsl

Please help me get out from this problme. I can't work with it

Regards

Rakib

Rakib (Finance Professional) (30 Points)
Replied 18 August 2015

Suppose income is 1,000,000

1st 250,000 0% -

Next 400,000 5% 20,000

Next 350,000 10% 35,000

Total 1,000,000 Tax 55,000

Rakib (Finance Professional) (30 Points)
Replied 18 August 2015

	Suppose income is	4,800,000
1st	250,000	0%	-
Next	400,000	10%	40,000
Next	500,000	15%	75,000
Next	600,000	20%	120,000
Next	3,000,000	25%	750,000
Next	50,000	30%	15,000

Total	4,800,000	Tax	1,000,000

S. Shiroor (Others) (1207 Points)
Replied 18 August 2015

Function Taxs(Inco)
Select Case Inco
Case Is < 250000
Taxs = 0
Case Is <= 650000
Taxs = (Inco - 250000) * 0.1
Case Is <= 1150000
Taxs = 40000 + (Inco - 650000) * 0.15
Case Is <= 1750000
Taxs = 115000 + (Inco - 1150000) * 0.2
Case Is <= 4750000
Taxs = 235000 + (Inco - 1750000) * 0.25
Case Is > 4750000
Taxs = 985000 + (Inco - 4750000) * 0.3
Case Else
"Error"
End Select

End Function