Using LET to make Excel formulas more readable
Sep 13, 2021
The introduction of LET function is fantastic.
To use the LET function in Excel, you define pairs of names and associated values, and a calculation that uses them all. You must define at least one name/value pair (a variable), and LET supports up to 126.
Look at this problem statement:
We need to know how many customers will get an incentive, based on meeting all following conditions:
a. Either of the Product Goals has to be met
b. Achievement has to be more than 100%
c. Should have been with company for > 2 years
The formula is:
Results are:
