Can I set multiple "validities" in a Calc spreadsheet?

I am creating a “spreadsheet application” where, epending on 3 “inputs” a validity selection will be made. The “validities” vary as to “US inch,” “US mm,” “UK mm,” “ISO mm,” DIN mm," or “JIS mm.” I would like to have the “final choice” operate in a single location. Can it be accomplished and, if so, how?

Is your question the same as this?