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 than 45  = 4

 

 

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
)

1 Reply

  • 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
)