I have set up a validation field giving 5 options from which to choose in
ColB. In ColA a number field requires a manual entry, ColC is the result of
ColA x ColB (which should vary based on the choice made from the drop menu
choice in ColB).

Question is how to apply a differnet (hidden) formula to each of the
different text options in the drop down validation menu?

Many thanks in advance.
Regards ...Andrew