Custom column based on same column values

[Anonymous]

how to create Custom column based on same column values using between operator ?? 

example:i have a column with values range from 0 to 10..i wanted to create custom column based on the condition.(ie).0-5 as custom column and 5 -10 as other custom column.. 

[Sean · Accepted solution]

If I understand this right you may be overthinking this.

Just a simple if statement would do.

You may have to change this a bit but here it is depending on where you want the 5 included 

Custom Column =
IF ( Table[Column] < 6, "0-5", "6-10" )

Good Luck! 

[nmck86 · Accepted solution]

I would do a conditional column in query editor based on the logic above. If less than or equal to 6 then... etc.

 

[Sean]

Yes that works too! In fact that’s what I would do too! 

[Sean · Accepted solution]

If I understand this right you may be overthinking this.

Just a simple if statement would do.

You may have to change this a bit but here it is depending on where you want the 5 included 

Custom Column =
IF ( Table[Column] < 6, "0-5", "6-10" )

Good Luck!