Tax Calculation

[Arup Dutta Chowdhury]

I have an excel file where I have to calculate the tax amount according to the old and new tax slab. In the Type column when I select the old or new it get automatically change as per old or new tax slab. I have written the answer of the tax amount for your help as per the old tax slab. Now how to change the amount as per old and new regime. The tax slab is like this.

Old Tax	Slab		New Tax	Slab
0-2500000	0​		0-2500000	0​
>250000 - <=500000	10%​		>250000 - <=500000	5%​
>500000 - <=1000000	20%​		>500000 - <=750000	10%​
>1000000	30%​		>750000 - <=1000000	15%​
			>1000000 - <=1250000	20%​
			>1250000 - <=1500000	25%​
			>1500000	30%​

 

[Arup Dutta Chowdhury]

Please help

 

[vletm]

Arup Dutta Chowdhury
You could continue from this ...

 

[Peter Bartholomew]

... or an Excel 365 solution ...

 

[Arup Dutta Chowdhury]

Hi the tax amount is not getting changed when we are selecting old or new from the type. The amount should change as per new or old tax slab.

 

[Peter Bartholomew]

True. It never occurred to me that it should!

 

[Arup Dutta Chowdhury]

Hi Peter I am using excel 2019. It is not happening in that. Can u do it in excel 2019 and send it. I don't have office 365.

 

[vletm]

Arup Dutta Chowdhury
As Your original thread is Now how to change the amount as per old and new regime.
for cell d2 = if(b2="Old","Old Tax formula","New Tax Formula") and copy down

 

[Arup Dutta Chowdhury]

Hi vietm I am unable to do it. Can you show in in the excel file. I will be a great help for me.

 

[vletm]

Arup Dutta Chowdhury
As You wished

 

[Arup Dutta Chowdhury]

Thank you