View original (French)

[Excel] Assign value to derived list text

Solved
cestbibi Posted messages 8 Status Membre -  
gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   -
Hello everyone,

I am creating an Excel file with a dropdown list with 4 choices.
I would like to perform a calculation in another column where each choice from my dropdown list corresponds to a value.
My dropdown list consists of the choices: full, three-quarters full, half full, and three-quarters empty.
I want to perform a calculation in another column where if the choice from the dropdown list is full, the value used in the calculation will be 1, if the choice is three-quarters full the value will be 0.75, etc.

Thank you in advance for your responses.

Best regards

Configuration: Windows XP / Firefox 3.6.6

3 réponses

Réponse 1 / 3
gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   4 742
 
Hello

To obtain the value used in your calculation, you can use (with your choice in A1) this formula: 

=CHOOSE(MATCH(A1;{"full";"three quarters full";"half full";"three quarters empty"};0);1;0.75;0.5;0.25)

Of course, you can "drag" this formula across your column or name your formula to simplify your calculations.
--

Always zen
6
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
Hello gbinforme,
I’m going to pick this one up on the way.
Thank you.
Best regards.
The Penguin
0
AD80
 
Hello, would it be possible to do it in English please?
0
gbinforme Posted messages 14930 Registration date   Status Contributeur Last intervention   4 742
 
You should also use the tools available ;-)
0