Income tax calculation

I have given solution in ur other post.

The above solution is for  India for AY 2015-16

and Not to your problem

Directly in excel sheet  it is slightly cumbersome

=IF(D12>4750000,(D12-4750000)*0.3+985000,IF(D12>1750000,(D12-1750000)*0.25+235000,IF(D12>1150000*(D12-650000)*0.2+115000,(D12-650000)*0.15,IF(D12>250000,(D12-250000)*0.1,0))))

I hope this helps

Sorry some mistake

=IF(D12>4750000,(D12-4750000)*0.3+985000,IF(D12>1750000,(D12-1750000)*0.25+235000,IF(D12>1150000,(D12-1150000)*0.2+115000,IF(D12>650000,(D12-650000)*0.15+40000,IF(D12>250000,(D12-250000)*0.1,0)))))

i hope this helps

In case you are new to VBA then step by step method

1] Step 1:- Click on file -- options-- Customize ribbon -- check the developer tab on right

   Now you will see the developer tab in main XL sheet

2] Step 2:-  Click on developer tab -- visual basic -- Vb window will open [ur xl sheet is minimised]

     In VB window click Tools--reference--check on the Visual basic for apllications and the object library.

3] Step 3 :- on the left is the object browser. Click and highlight ur xl sheet. Then click insert and then module. 

4] Step 4:-  Paste the following code in the module

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
                 
     End Select
       
End Function

5] Step 5:- close the vba window or minimise

6] step 6 :-  in ur excel sheet  type  =Taxs(A5)  WHERE A5 CONTAINS TAXABLE INCOME

I have made it as clear as possible.
hope this helps   Cheers