Specific Formulas
Ranges of Numbers Values
Inspiration
Sometimes you want to arrange the value in a number field into a set of ranges.
You can then group on this range to make it easier to work with records in specific ranges.
Discussion
Use a nested IF to convert a number field to a range.
IF(
{number} < 10,
"small",
IF(
{number} < 20,
"medium",
IF(
{number} < 30,
"large",
"extra large"
)))
Thank Kuovonne for creating this content!
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.