Forum Discussion
Nested IF formula
Hi, I am trying to use the below formula to analyze some data however the formula seems to be stopping at "Medium" and going no further. I have also tried to use the "IFS" function but that is j...
Hello Claire
A simple LOOKUP()-formula will do:
=LOOKUP(G2,{0;1;5;10;15},{"";"Low";"Medium";"High";"Very High"})