Nested IF formula

[Claire Fox]

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 just returning "Name?" error message.  Does someone know why this might not be going further than "Medium".  I read somewhere this is a problem with Nested IF but I am hoping there is a workaround.

=IF(G2=0,"",IF(G2<4,"Low",IF(G2=5,"Medium",IF(G2>5,"Medium",IF(G2<10,"Medium",IF(G2=10,"High",IF(G2>10,"High",IF(G2<15,"High",IF(G2=15,"Very High",IF(G2>15,"Very High"))))))))))

I also tried this.

=IFS(G2=0,"NIL", G2<5,"Low",G2>5, "Medium", G2>10,"High",G2>15,"Very High")

Would appreciate any help.

Thanks,

Claire

[#2]

Hello Claire

A simple LOOKUP()-formula will do:

=LOOKUP(G2,{0;1;5;10;15},{"";"Low";"Medium";"High";"Very High"})

[#3]

Worked like a charm! Thanks! I do not use Lookup formulas every day so very rusty!