Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Applying a formula to a drop menu choice
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 |
#2
|
|||
|
|||
A more elaborate specification would help, but it looks like...
C2: =CHOOSE(MATCH(B2,DataValidationList,1),Expression1 ,Expression2,Expression3,Expression4,Expression5) ExpressionN is an calculation that involves A2 (user entry) which depends on the choice from B2. DataValidationList is the list used to data validate B2. Andrew Hill wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|