Formula is showing In Correct

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

Developer

Developer Tools

Accepted answers

Bren_Spill2

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

Count2.yxmd

All comments

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

Count Pic.JPG

Count.yxmd

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.

Count.yxmd

Output- Count Per Country.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703