Formula if, elif, else

Solved!
MS
Level 3
Formula if, elif, else

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?

1 Solution
Liev
Dataiker Alumni

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!

View solution in original post

2 Replies
Liev
Dataiker Alumni

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!

MS
Level 3
Author

Thanks