Nested and multiple If else statements

Question

Hi All, I have a field denoting number of years as shown below and based on the value, I need to categorize as mentioned buckets as a new column. I tried standard if, if else statements and alteryx is giving me the malformed function cell error. Please can someone tell me the best way to categorize this ? Attached input and output col in file.

* <1 year
* 1-2 years
* 2-5 years
* 5-7 years
* 7-10 years
* 10-25 years
* >25 years

No of years                 (0.56)                  0.73                  1.70                24.46                23.46                17.05                (0.56)                  4.45                  6.96                13.45                18.33                17.05                  4.45                24.46                17.05                  1.10                17.05                24.46                23.46                24.46                23.46                24.46

test.xlsx

messi007 · Accepted Answer

@Mj9715,

Please see below how you can do it

Attached the workflow.

Regards,

Mj9715 · Accepted Answer

Hi @messi007 - I had tried this exact formula and so far so good, the syntax shows up well. The minute I finish typing "endif" , the formula shows an error. Please can you refer to screenshot one and two respectively and see what I am doing wrong?

afv2688 · Accepted Answer

Hello @Mj9715 ,

This usually means that you have the field in the incorrect data type. For example, if you are trying in this case to apply a comparative between to values and one of them is a string, it doesn't make a sense for it. You need to transform them into a number field:

Regards