How to Calculate Income Tax in NEW Tax Regime using Ms-Excel - Using MAX() and IF() Function

preview_player
Показать описание
Join into Telegram Public Group for Daily Tricks and Tips:

View All #1MinuteSnippets here:

View All #DoItWithMe series here:
Рекомендации по теме
Комментарии
Автор

Can you please complete this marginal relief formula need to put a further argument to complete the formula for the salary income upto 7, 27, 000/-

BonaventureVaz
Автор

I don't know but in my case the formula is not working properly as per the new tax regime. It is ok when the amount is only 7lpa, but if you apply the same on more than 15lpa it is not working. Please correct me.

janaksingh
Автор

Because sir when I calculate the tax on any calculator by new regime tax rebate for new regime above 751000 tax is 1040 description is merginal rebate please tell me formula

aslamanjum
Автор

Thankyou so much sir for this formula .

YogeshwarBharti
Автор

If margin relief is there sir what is the formula pls tell us

lokeshbhasker
Автор

Sir I don't know what is the formula of sec 87a merginal rebate can I get the formula for new regime

aslamanjum