Running LET() function as a loop

I have a long LET() function where I define a number of variable but with one of them being a range. Subsequently, I have a number of calculations which depend on the range but I want to make sure that all of the calculations are run fully with the first number in the range before the calculations are done again with the second number in the range. The formula works when calculating with a single number but not with the range. How can I solve this? (I don't have access to LAMBDA, SCAN etc. due to semi annual channel)

Example:
Range {1,3,5}
when range=1, result=20
when range=3, result=50
when range=5, result=26

So I want the result of the formula being {20,50,26}, how do I ensure this?

Formula looks like this where I would like to run a loop for the second part based on the range from "peaks_position"

Please Login or Register  to view this content.

Moly, welcome to the forum.

Unfortunately, there are 2 problems with your post....

1. you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I have added them for you - this time

2. it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(I have added the link for you - this time... https://www.mrexcel.com/board/thread...-loop.1222696/ )

I don't have access to LAMBDA, SCAN etc. due to semi annual channel

I think you should have MAP ... LAMBDA because MAP ... LAMBDA is introduced in december 2020.

Please try

Formula:

Please Login or Register  to view this content.

and replace in the formula the value(s) that should be respectively 1, 3 and 5 by x.
In stead of x you can also choose another name.

EDIT: Attached a workbook with an example map:

Formula:

Please Login or Register  to view this content.

Example 2; Nice to know its also possible to add more parameters. For example

Formula:

Please Login or Register  to view this content.

If you don't have a MAP LAMBDA in EXCEL 365 then it looks like your version of EXCEL 365 is at least 2 years old.

In that case you can try to replace the value that should be 1, 3 or 5 respectively with {1,3,5} in your formula.
[And confirm your formula with CTRL+SHIFT+ENTER].

But unfortunally that doesn't always work.
That can only work for functions that are normally only offered a single value in the place where you replaced this value by {1,3,5}.