March 21, 2019 at 2:50 pm
#857

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