Forum Discussion
Solved
Multiple IF functions in one formula
Hi, I am new here and I have a problem with a project regarding a formula. Excel is saying #Value, which off course is not a good sign. I have a list with values below each other from: 1 to 25 (2...
You mentioned "between 5 and 12" = medium and ">12" = high. So 12 should be medium.
(Also, I think it should be "between 6 and 12")
You can use
=LOOKUP(B2;{1\6\13};{"Low"\"Medium"\"High"})
or create a lookup list:
And use either
=VLOOKUP(B2;$G$2:$H$4;2)
or
=XLOOKUP(B2;$G$2:$G$4;$H$2:$H$4;"")
The advantage of the lookup list is that it's easy to change the thresholds - you have to do it only in one place instead of in each formula.
Please apply the simple formula
=IF(A1<=5,"Low",IF(AND(A1>=6,A1<12),"Medium",IF(A1>=12,"High",0))) or
=IFS(A1<=5,"Low",AND(A1>=6,A1<12),"Medium",A1>=12,"High",TRUE,0)
It depends on range, need to design from start of range and end of range.
=IF(A1<=5,"Low",IF(AND(A1>=6,A1<12),"Medium",IF(A1>=12,"High",0))) or
=IFS(A1<=5,"Low",AND(A1>=6,A1<12),"Medium",A1>=12,"High",TRUE,0)
It depends on range, need to design from start of range and end of range.
Goodmorning,
Many thanks for the reply. When I was reading your formula, it sounded very logical to me. Only too late 🙂 🙂