Summary: In this video, Mr. Raj Singh Sir will teach you how to use APPROX MATCH Formula in a more advanced form. Using the example of tax calculation you will learn how to calculate tax amount.
Formulas: (follow the video for better understanding)
To calculate tax
=SALARY*6%
=SALARY-TAX AMOUNT
=VLOOKUP(LOOKUP VALUE, TABLEARRAY, COLUMNINDEXNUMBER, RANGELOOKUP)
Conclusion: In this video, you learned how to calculate tax from complex and big data with some simple tricks.