Formula is showing In Correct

[duttaabhishek]

Hi I have the below dataset. The Column "Count" is the original Dataset. I want to add a column "Risk Score" as per the count using IF ELSE Formula. I am using a formula which is showing incorrect. Please help 

Count	Risk Score (This column needs to be Added as per the COunt COlumn
0	1
1 - 5	2
6 - 10	3
11 - 15	4
16 - 20	5
21 - 30	6
31 - 40	7
41 - 50	8
51- 70	9
71 - 90	10

[Bren_Spill2]

@duttaabhishek - instead of creating a formula, you could use Find Replace and use the table below as your lookup. See attached.

If you want to use a formula, try this (and add in the rest of the categories):

 

[duttaabhishek]

Hello @Bren_Spill2 Thanks.

I also thought of using the FInd/Replace Tool. But in the FInd replace tool I am unable to view the appropriate column inside "FInd Within Field" Section within the FInd Replace TOol. I am attaching the Base Input file also from which the tool is required to "FInd Within FIeld". I am only able to see the COlumn "Country" however I need the column "Count" to be visible in the "Find within the field section" in the FInd/replace tool. 

[Bren_Spill2 · Accepted solution]

@duttaabhishek - see attached an alternative approach using the Tile tool