I'm trying to create a complex set of variables in an excel
spreadsheet. Since I am not a strong programmer, the best way to do
this is to basically use a very complex if/then argument. However,
excel only supports 7 nested conditionals.

Basically, what i want to do is "teach" excel the notes of a music
keyboard in terms of number.

Ex 60 = C, 61 = Db, 62 = D etc etc...and so on for all 127 notes of a
midi keyboard.

In other words, like an array or list that I can do calculations with.

Any advice?