I could probably test this out, but I figure one of you know this off the top of your head!

Are variables set in the LET function created sequentially so I could, say, use the first two variables as part of the third's?

I could probably test this out, but I figure one of you know this off the top of your head!

Are variables set in the LET function created sequentially so I could, say, use the first two variables as part of the third's?

Beat you to it... just wrote a formula, and the answer is "yes."

Oops, I see I did have and answer! I'm considering how I can use the Auto insert calculated value formula to format phone numbers, but to a higher degree... strip off any leading 1, add the local area code if there isn't one, format the number correctly, add extension if there is one, and include any post-text: "cell", "work", "wife", etc.

I'm sure it's been done, but figuring out how to do this in a single formula sounds like a fun challenge to me!

- 4 people found this helpful
Almost everywhere calculation is done left to right, but aggregate functions do it right to left (found no document).

Let($$a=1;

Average(Let($$a=$$a+2;$$a);Let($$a=$$a*3;$$a))

)

results 4, not Average(3;9) but Average(5;3)

I found this past on List(), but now tested on FM16v2 Min(), Max(), Sum() and Average() also behave same.

Yes. In fact, this is a good practice.