Reply To: breaking numeric data into groups or categories

#857
Bill Finzer
Keymaster

Suppose we have numeric values ranging from 1 to 100 that we wish to break into three groups: “low,” “medium,” and “high.”

We use the formula:

if(Number<33,”low”,
if(Number<66,”medium”,”high”))

The screenshot shows the formula for this as it appears in the formula editor.

Hope that helps.

Bill

Attachments: