Forum Discussion
How does Excel calculate named formulas and materialized named ranges?
I have been creating utility formulas with AFE to make my lambdas more readable and maintainable, for example: ManualAllocRng =OFFSET(ManualAllocCorner,1,0,URows,EntityCount); How does Excel calcul...
Hello boukasa
Happy Holidays!
Are you asking if a LAMBDA function is volatile or not?
The answer is NO, LAMBDA functions (by default) are NOT volatile, and they are only recalculated once one of their arguments change value. So, in your example both will function the same way.
And YES a LAMBDA can become volatile if one of their arguments is a volatile function such as NOW(), RAND(), INDIRECT() as examples of many other volatile functions.
I hope this helps
GiGi...