Formula if, elif, else

Options
MS
MS Partner, Registered Posts: 28 Partner

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?

Best Answer

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭
    edited 3:36PM Answer ✓
    Options

    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!

Answers

Setup Info
    Tags
      Help me…