Hi everyone,
I have a variable number ranging between 0 and 127 in box E2 of my spreadsheet. I want to interpret that value in box E1 according to the following table:
http://andymurkin.files.wordpress.co...e-no-chart.jpg
For instance, 0 in E2 should show C-1 in box E1, 1 should be C#-1, 2 should be D-1 and so on.
Anyone has an idea how I can do this ? I am quite a beginner so the more simple the better...
Cheers!
Pierre
Bookmarks