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