Forum

Notifications
Clear all

Tax Calculation

2 Posts
2 Users
0 Reactions
147 Views
(@arupduttachowdhurygmail-com)
Posts: 1
New Member
Topic starter
 

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 will select the old or new it will 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 help me to change the tax amount as per old or new tax slab. 

 
Posted : 25/06/2021 12:57 pm
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

Hello,

This looks like a school project, but you can use the INDIRECT function together with &"Slabs" to connect to the different slabs tables, OldSlabs when selecting Old or NewSlabs when selecting New.

Good luck with your home work.

Br,
Anders

 
Posted : 25/06/2021 3:32 pm
Share: