Save Rs 499 on a 2-Year Ad-Free CAclubindia Pro Membership. Subscribe Now!

Excel formula as per new slab.

Save Share

Join Us Follow Us Add as Source

This query is : Resolved

Report Follow Query Ask a Query

Querist : Anonymous

Querist : Anonymous (Querist)

24 December 2013 hi,

can anyone help me by providing excel formula as per new slab of income tax.

Thanks

@VaibhavJ

@VaibhavJ (Expert)
Follow

24 December 2013 Hi,

=ROUND(IF(A3<200001,0,IF(A3<500001,(A3-200000)*0.1,IF(A3<1000001,(A3-500000)*0.2+30000,(A3-1000000)*0.3+130000))),0)

Where A3 contains Net Taxable Income.

Thanks//VaibhavJ

Querist : Anonymous

Querist : Anonymous (Querist)

25 December 2013 thanks sir,

but i need as per new slab after deducting 2000 ((200000 to 500000)-rebate 2000)my value comes in subtraction i want to make it 0

Thanks

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!