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% ...
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