The doc says
calculation-or-name: A name to give another variable to define or a calculation that uses names in the LET function. Must be the last argument.
I understand how to use it as a "calculation": this is the result of calling the function. But could someone give me an example of how I would use it as a "name"?
I do think it is a little ambiguous, and understand the confusion, but it's how Numbers' describes function parameters
The best way to understand it (I think), is to step back a little and look at the LET() function in pieces.
At its very least, LET() has two mandatory arguments, a variable name and a value.
LET() does support multiple name/value pairs (up to 126 pairs)
After each name/value pair, the documentation indicates calculation-or-name. This really means that the next argument can either be a calculation (based on the previously named variables), or it can be a name for a new name/value pair.
So there's never a case where you have a name on its own, it's really an indicator that you need to specify either the calculation that you want, or start a new name/value pair.
In Apple Numbers, what is the use of the "calculation-or-name" parameter of LET?
