Hire From Us

New Feature

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.

Please enable JavaScript in your browser to complete this form.
Please enable JavaScript in your browser to complete this form.