Gallery
Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Specific Formulas

Ranges of Numbers Values

Thank Kuovonne for creating this content!

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!
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.