CalCPA LET Article
Often, our Excel formulas are simple and short. As such, they are easy to read, understand and maintain over time. But, as the complexity of our workbooks increases, so can the complexity of our formulas. Sometimes, we end up with unwieldy formulas that are long and difficult to understand and maintain. One cause for such lengthy formulas is duplication.
As a general rule of thumb, eliminating duplication within formulas makes them easier to read and perhaps more important, maintain over time. Although there are many ways Excel users have tried to minimize formula duplication over the years, we have a great new option in the LET function. If you’d like to learn more, check out the full article below.
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.