Need to use formuale tool to perform two cheks ata time.

[Sameer_Kanade8810]

Hi all So my data se has a column name as CODE and these are integers in nature. Just like below 

What i need is to  Filter on code column where SCC => 900 (exclusive of 901, 902, 903, 915, 920, 921, 925, 929, 931, 932 and 933); update the CATEGORY column for these rows to reflect ‘SCC 900 Range’.
CODE
900
901
902
903

904
905

906

920

921

can some one help me achieve this

 

[Raj]

@Sameer_Kanade8810 |
if [CODE] >=900 and [CODE] not in (901, 902, 903, 915, 920, 921, 925, 929, 931, 932, 933) then "SCC 900 Range" else [CODE] endif

please find the formula attached

mark done if solved.

[Bren_Spill2]

@Sameer_Kanade8810 - see solution attached

[Raj]

@Sameer_Kanade8810 
workflow attached for reference.

[Raj]

@Sameer_Kanade8810 
is this solved.