Forum Discussion
Formula Challenge: Create a guitar fretboard diagram
This exercise has helped in my ongoing studies of Excel and learning acoustic guitar. The challenge is to produce the standard tuning (E-A-D-G-B-E) diagram: [This diagram lists 'natural' n...
I tried to answer but I couldn't get past the dreaded HTML error!
Basically, you are correct in that parameters are passed left to right.
Starting out with anonymous Lambda functions may help with the syntax, and then the code, starting with LAMBDA and ending with the closing parenthesis, are replaced by the Lambda name.
- yes I too have had some dreadful HTML error issues. I wonder what changed.
I will try to post a code snippet.
Another place where arguments are read from left to right is Curried functions
= LAMBDA(x,LAMBDA(y,LAMBDA(z, (x+y)/z)))(3)(5)(2) gives = (3+5)/2 = 4 or, with naming, CurriedLambda = LAMBDA(x,LAMBDA(y,LAMBDA(z, (x+y)/z))) = CurriedLambda(3)(5)(2) also gives 4The final parameter can also be provided by a helper function
= MAP({2;3;4}, CurriedLambda(3)(5)) gives = {4.00; 2.67; 2.00}- Seems to work. I don't know what was happening before.
