Watch on YouTube
(Embed)
94
0
Genre: Education
License: Standard YouTube license
Family friendly? Yes
Shared January 25, 2026
👉🏻Salary calculations are so difficult if the numbers and expressions for formula is not accurately defined.
👉🏻LET function in Microsoft Excel allow users to create a single formula based on your requirements and use it for rest of data.
👉🏻Indeed, LET function must be applied step by step and formula must be written with atmost care.
👉🏻Formula used in Video
=LET(salary,A2,
bonus,salary*B2,
tax,salary*C2,
salary+bonus-tax)
☑️ Note:- To Go to next line after completing one line press ALT & Enter key from the keyboard.
📌Subscribe @magicalexcel if you want to learn Basic to Advanced formulas and functions
