View original (French)

[Excel] Assign value to derived list text

Solved
cestbibi Posted messages 8 Status Member -  
gbinforme Posted messages 14930 Registration date   Status Contributor 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 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    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
    1. Le Pingou Posted messages 12275 Registration date   Status Contributor Last intervention   1 477
       
      Hello gbinforme,
      I’m going to pick this one up on the way.
      Thank you.
      Best regards.
      The Penguin
      0
    2. AD80
       
      Hello, would it be possible to do it in English please?
      0
    3. gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
       
      You should also use the tools available ;-)
      0