Class 35: Approx Match Part 2 Copy Copy

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.