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)- 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?
