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.