Forum Discussion

Vanessa250919's avatar
Vanessa250919
Helper V
4 years ago

IF condition multiple

Hello COmmunity,

 

I try to used IF with multiple condition but does't worked ...

AmountPrime = IF([Med%]>1.15,"5€", [Med%] >1.2,"20€")
 
I need MED% < 115% = NOT
MED%>= 115% = 5€
MED% >120% = 10€
 
It's possible ? 

3 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    4 years ago

    You need to create a concatenation of IF conditions, as follows:

    IF(Table[MED] < 1.15, "NOT", IF(Table[MED] >= 1.15 || Table[MED] < 1.20, "5 euro", IF(Table[MED] > 1.20, "10 euro", BLANK())))
     
    is that what you wanted?
    B.
     
    • Vanessa250919's avatar
      Vanessa250919
      Helper V
      4 years ago

      BeaBF Yes it's that but I a big isssue if I make a formule with < it's not ok and > it's ok check my printscreen

      >

      <

      I don't know why ... it's same with SWITCH(TRUE 

  • BeaBF's avatar
    BeaBF
    Super User
    4 years ago
    Try this formula, where the first condition makes you avoid considering blanks:
    IF(ISBLANK(Tabella[Med%]), BLANK(), IF( Tabella[Med%] < 1.15, "NOT", IF(Tabella[Med%] >= 1.15 || Tabella[Med%] < 1.20, "5 euro", IF(Tabella[Med%] > 1.20, "10 euro", BLANK()))))
     
    It works?
    B.