Need Help to Evaluate an Impact Range

Am unsure how to best evaluate an impact range. Three attempt below. Would appreciate help to divine practical solution. Thanks in advance.

Impact Assessment

No Impact, 0 - .9
Very low Impact, 1 - 1.9
Low Impact, 2 - 2.9
Medium Impact, 3 - 3.9
High Impact, 4 - 4.9
Very High Impact, 5

I thought to evaluate and have tried these:

Attempt1, cannot get beyond first set of IF(OR
IF(
OR({xf.Impact Score Average}=0,“No Impact”,
{xf.Impact Score Average}<=1),“No Impact”,
IF(
OR(
{xf.Impact Score Average}=1,“Very Low Impact”,
{xf.Impact Score Average}<=2),“Very Low Impact”,“X”))

Attempt 2, does not appear to work
IF({xf.Impact Score Average}>0 <1,“No Impact”,“XX”)

Alternative 3, Appears to work but bit cumbersome
IF({xf.Impact Score Average}=0,“No Impact”,
IF({xf.Impact Score Average}=0.1,“No Impact”,
IF({xf.Impact Score Average}=0.2,“No Impact”,
IF({xf.Impact Score Average}=0.3,“No Impact”,
IF({xf.Impact Score Average}=0.4,“No Impact”,
IF({xf.Impact Score Average}=0.5,“No Impact”,
IF({xf.Impact Score Average}=0.6,“No Impact”,
IF({xf.Impact Score Average}=0.7,“No Impact”,
IF({xf.Impact Score Average}=0.8,“No Impact”,
IF({xf.Impact Score Average}=0.9,“No Impact”,
IF({xf.Impact Score Average}=1.0,“Very Low Impact”,
IF({xf.Impact Score Average}=1.1,“Very Low Impact”,
IF({xf.Impact Score Average}=1.2,“Very Low Impact”,
IF({xf.Impact Score Average}=1.3,“Very Low Impact”,
IF({xf.Impact Score Average}=1.4,“Very Low Impact”,
IF({xf.Impact Score Average}=1.5,“Very Low Impact”,
IF({xf.Impact Score Average}=1.6,“Very Low Impact”,
IF({xf.Impact Score Average}=1.7,“Very Low Impact”,
IF({xf.Impact Score Average}=1.8,“Very Low Impact”,
IF({xf.Impact Score Average}=1.9,“Very Low Impact”,
IF({xf.Impact Score Average}=2.0,“Low Impact”,
IF({xf.Impact Score Average}=2.1,“Low Impact”,
IF({xf.Impact Score Average}=2.2,“Low Impact”,
IF({xf.Impact Score Average}=2.3,“Low Impact”,
IF({xf.Impact Score Average}=2.4,“Low Impact”,
IF({xf.Impact Score Average}=2.5,“Low Impact”,
IF({xf.Impact Score Average}=2.6,“Medium Impact”,
IF({xf.Impact Score Average}=2.7,“Medium Impact”,
IF({xf.Impact Score Average}=2.8,“Medium Impact”,
IF({xf.Impact Score Average}=2.9,“Medium Impact”,
IF({xf.Impact Score Average}=3.0,“Medium Impact”,
IF({xf.Impact Score Average}=4.0,“High Impact”,
IF({xf.Impact Score Average}=5.0,“Very High Impact”)))))))))))))))))))))))))))))))))

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.