Help

Need Help to Evaluate an Impact Range

Topic Labels: Formulas
92 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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”)))))))))))))))))))))))))))))))))

0 Replies 0
Labels