Why negative numbers cannot be detected by the "Conditional column"

[JPY]

Hi all,

I am trying to add a conditional column to categorize column FR, however the negative numbers cannot be detected as shown below.

Kindly please advise how to solve it.

Thank you for your help!

[d_gosbell · Accepted solution]

This is a logic error. Every possible numeric value is satisfied by your first 2 conditions, so you will only get A or B. Delete the second condition ( if FR <= 35 then B) and everything should work fine.

[JPY]

Hi @d_gosbell 

I've tried your method, however, the correct values do not seem to fall into the correct category that I have intended it to be in. 

Here is the logic I want to apply:

1. If X>35 then A
2. If 5<X<35 then B
3. If X<=5 then C

How would I go about doing this?

Thank you for your reply!

[JPY]

Hi @d_gosbell,

Pls ignore the above question, your method worked.

Thanks!!