Kuovonne's Guide to Airtable

Share

Explore

Kuovonne's Guide to Airtable

Specific Formulas

Ranges of Numbers Values
Ranges of Numbers Values

⁠

⁠ Tip Jar ⁠ 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! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

⁠

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.