Hi ,
Can any body provide the excel sheet of formula to be used for calculating the income tax slabs for different Incomes.
Thanks
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).
Vivek B. Bhinde
(Action Creates Energy !!)
(824 Points)
Replied 03 April 2013
The Income Tax Calculator is hereby attached....
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...
Swapnil
(student)
(23 Points)
Replied 26 December 2013
Swapnil
(student)
(23 Points)
Replied 26 December 2013
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)))) |
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
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:
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
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
LIVE Course on Foreign Exchange Management Act (FEMA)(with recording)
LIVE Form 10 B and Form 10BB: Handle Tax Audit Reports of Charitable Organizations(with recording)