Forum Discussion
F9 Evaluation KEY to be available inside LET Functions throughout Excel, PQ, BI (That is Missing)!
I couldn't see any benefit of using LET function, because F9 Evaluation key is not working inside LET, and that makes it very difficult to use it. I request Microsoft team to add F9 key throughout it...
=LET(u,UNIQUE(B4:B18),u)
This is the syntax you have to use in order to calculate the result of a name (name1 equals u in this example).
Syntax of let function is: =LET(name1,name1_value,calculation_or_name2.......)
" calculation_or_name2 " allows the calculation of the result of u (=name1) in this example.
- The formula which I mentioned in pdf is absolutely correct. The issue is, inside the LET function, we cannot able to evaluate via F9 key. And this is the real issue in the newly LET formula, F9 evaluation key must work throughout excel platform.
