Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
What's the formula for if, elif,else?
I have 3 categories in column M and with formula i try if(M<0, "negative", "positive","neutre") don't work !!
Do you have another formula?
Hi @MS
You could try
if(M<0, "negative", if(M>0, "positive","neutre"))
Alternatively, you could use a Python processor and use if,elif,else as you seem to want.
I hope this helps!
Hi @MS
You could try
if(M<0, "negative", if(M>0, "positive","neutre"))
Alternatively, you could use a Python processor and use if,elif,else as you seem to want.
I hope this helps!
Thanks