Multiplying custom values
I have a drop- down list with numbers (1,2,3,4,5) let's call it "numbers".
And then I have another drop-down list with custom values (A,B,C,D...) let's call it "codes"
I want to create a "result" field to get a specific value.
A general type of what I want to do is numbers*codes=result
Every code must have a specific, unique value, such as A=100, B=125, C=134, D=346 and so on. Note that these values are always the same. A will always equal 100.
numbers = 1 * codes = B, result = 125
numbers = 3 * codes = C, result = 402 etc...
How should I proceed? I am a newbie, so please be thorough...
Thank you very much!