Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
147
Views
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
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