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'm trying to fully understand passing multiple parameters. I've created a sample Lambda (its name is the name of a measurement system but for some reason cannot be posted here?):
I then call this function within MAP.
This is the part that was a bit foreign to me. I'm not providing the function with its parameters within parenthesis but rather, it seems to be inferred the function is pulling them left-to-right from the 3 arrays I've given MAP. I hope I'm understanding this clearly.
Edit: the formula snippets cannot be posted because of the function name it seems. Please see attached workbook.
it appears you reversed your imp and met in the call in the cell:
=MAP(E2#,imp,met,Imperial)
should be
=MAP(E2#,met,imp,Imperial)
=MAP(E2#,imp,met,Imperial)
should be
=MAP(E2#,met,imp,Imperial)
- Good catch. I was testing the order of the arrays and forgot to switch it back.
Your latest version w/o Lambda: .00088 average calc time- which one I had 2 in that file (& post) or did they each perform the same?
- That was for the top one. The bottom solution clocked in at .00083 (Average of 5 timings).