Looking for an equation to convert a given letter to a figure, as an answer to a question. The question can be answered by many letters where each letter equating to a different figure,ie answer A means 20, B means 50, C means 37.50 and so on.
Column A, question. Column B, answer. Column C, the figure.