Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating a number range between two values

how to create a range of values from a column Example   numerical values 10 20 25 30 35 40 45   need ranges from 10 - 30 = 1 range from 31 to 40 = 2 range from 41 to 45 = 3 greater tha...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous add new column and use swtich function

     

    Range = 
SWITCH( TRUE(),
Table[Number Value] > 45, 4,
Table[Number Value] > 40, 3,
Table[Number Value] > 30, 2,
Table[Number Value] > 9, 1
)
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous add new column and use swtich function

 

Range = 
SWITCH( TRUE(),
Table[Number Value] > 45, 4,
Table[Number Value] > 40, 3,
Table[Number Value] > 30, 2,
Table[Number Value] > 9, 1
)