If then else

Hi everyone
I want to know if i can choose more than one criteria in the same first area
For example :
If column 1 is …(then i can make a list instead of creating multiple rows of “OR” repeating same thing 30 times)
i dont know if it’s unerstandable.
Tanks for your help
Pierr

Not really. Can you give a more concrete example of what you are trying to do?

Show me what your input is, and what your desired output is.

1 Like

I have a list which is the source of 8 choices.
Then the answer is written in column CHOIX EXO 1, 2…
I want to set a value (1 to 4) according to the result. (column Coeff)
If CHOIX EXO 1 is or includes several words in the list = 1 or 2 or 3 or 4.
For example : if CHOIX EXO 1 includes chenille or épaules or i want result 1.
My question is can i suggest several words in “enter value” or should i repeat the process for every word.

Thanks Darren.
Helpful as always


You’d have to repeat it, but you can do that within a single if-then-else column. It would be something like:

  • If CHOIX EXO 1 includes chenille, then 1
  • If CHOIX EXO 1 includes épaules, then 1
  • etc…

An alternative would be to use a JavaScript column.

Ok.
Thanks

For java. I’m not that good.

How many cases in total do you have? If there are too many, JS is a better alternative.

  1. i found a solution renaming cells.
    thanks

Can you explain what you mean by “renaming cells”? It can help people who read this topic later.

Every terms in the data list i use for the choice are renamed according to the future category i want to have. So i wrote (1) or (2) or (3) or (4) inside.
Then when user pick the choice it includes (1) or (2)…and i can have what i wanted.