Excel formula for calculating slabs

147274 views 38 replies

 

 

Hi ,

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

 

Thanks

 

Replies (38)
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).

The Income Tax Calculator is hereby attached....

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

It is not working, if a person having income of Rs Rs. 10,00,000. Kindly copy Properly
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,)))))

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))))

thanks Amit....

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

 

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

Thanks.

 

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

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

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

                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

 

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

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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register