What it does
Simplifies a complex formula by applying the LET function to remove redundant formula parts.

When to use it
When you want to make your formulas easier to read and calculate faster by removing redundant formula parts.

Why to use it
It’s a very quick way to automatically apply the LET function to a formula and replace redundant formula parts with names and definitions.

Default shortcut
None

Other Details

• Category: Formulas / General
• Difficulty: 2/5
• Usage/frequency: 3/5
• Automation factor: 4/5 (estimated 180 seconds saved each time used)
• Type: Shortcut
• Date added: 2/17/2026
• Tags: LET, formula

Related Macros
Mapify Formula
Lambdafy Formula

Other Articles
None

Letify Formula Example

Prerequisites
Select a cell with a formula that contains repeating formula parts (calculations, cell range references, or constant values).

Instructions
Run the Letify Formula macro.  The formula is evaluated for repeating formula parts.  If any are found, the formula is wrapped in the LET function and the repeating parts are added as named variables, which simplifies the formula.  The previous formula is added to a cell note in case you need to revert it.