Make decisions
Name a step inside a formula (LET)
=LET(x,A2*2,x+1)How it works in Excel
- x is a name you choose.
- A2*2 is what x stands for.
- x+1 is the final result.
- It saves repeating the same calculation.
- It needs Excel 2021 or Microsoft 365.
The idea in general
You give a step a short name, then use the name.
What I assumed
- The number is in A2.
Check the result on your own data before relying on it.