Run an Excel LET Calculation for Each Range Value Without LAMBDA
Question details
Run a complete LET calculation independently for each value in a range without LAMBDA, SCAN, or similar iteration functions.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A working LET formula needs to process each value in the named range peaks_position.
- Observed behavior
- The formula works for one value but does not repeat the complete calculation independently for every value in the range.
Identify which reference in the working formula represents the current input value and which ranges must remain fixed. Check that LET is available in your Excel version and that you have empty cells beside the input range for results or helper calculations.
Fill the LET Formula Down for Each Input Value
Use a separate copy of the working calculation for each input when it returns one result per value.
Find the first cell in the peaks_position range, such as A2, and select an empty cell on the same row for the result.
Enter the working LET formula in the result cell. Replace the reference used as the current input with the first input cell, such as A2; keep any references that must still use the full range.
In the formula bar, use absolute references such as $D$2:$D$100 for shared ranges that must not move when the formula is copied.
Select the result cell and drag its fill handle down alongside all values in peaks_position. Check that each copied formula refers to the input on its own row.

Split the Calculation Into Helper Columns
Use helper columns when the LET formula is difficult to adapt or when LET itself is unavailable.
Work With Per-Row Calculations in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. Open compatible Excel files and use filled-down formulas or helper columns for per-row calculations; check formula compatibility when moving a workbook between applications.

Frequently Asked Questions
Can LET run the whole calculation separately for every item in a range?
LET names intermediate expressions but does not itself provide a per-item iteration mechanism. Some expressions work on arrays directly, but a calculation that requires independent execution may need separate formulas or helper ranges.
How do I keep a lookup range from changing when I fill the formula down?
Edit the reference in the formula bar to use absolute references, such as $D$2:$D$100, before dragging the fill handle down.
What if LET is not available in my Excel version?
Move the intermediate expressions into helper columns, then enter a final formula that refers to those cells. Fill the formulas down for each input value.
Can I automate the repeated calculation without LAMBDA or SCAN?
VBA or a worksheet event may be appropriate if the workbook supports macros and the process must run automatically. Otherwise, filled-down formulas or helper columns avoid requiring macro code.




