Calculation question

[sodium]

Is it possible to use the iff function to choose different calculations depending on the selection in a certain column and return results in the new column,
Table layout example

Col 1 Drop down selection
Col 2 Amount
Col 3 Results of required calculation

small example if Col = 1 then use calculation 100xCol2 if Col1 = 2 then use calculation 200xCol2 etc etc the calculations are more complex but for explanation purposes the above will do.

Any help appreciated.

[June7]

It is possible. Use IIf or Switch or Choose.