Common unit


There are a large set of units, like currencies. You want to convert from one unit (the sources) to any other unit (the destination). There are many possible combinations.


Pick one of the units. Call it the common unit. Convert the value from the source unit to the common unit. Then convert the value from the common unit to the destination.


Use a Select Case statement. See Currency conversion for an example.