June 30, 2020
Using the numeric function formulas in Airtable can save you a lot of time when it comes to auto-magically calculating entries for you. Here are some of my favorite uses for them:
When you need the data to report an EVEN number
EVEN(value) → this will give you the next greatest even number
When you need the data to report an ODD number
ODD(value) → this will give you the next greatest odd number
When you want an INTEGER /no decimal numbers
INT(value) → this will remove any decimal points, regardless of formatting
When you want your data to be ROUNDED
ROUND(value,0) → this will round to the nearest whole number
When you want your data to be ROUNDED UP
ROUNDUP(value,0) → this will round up to the nearest whole number
When you want to pull up the LOWEST NUMERIC RESULT from other field
MIN(field1, field2…) → this will pull up the smallest value from those fields
When you want to pull up the HIGHEST NUMERIC RESULT from other field
MAX(field1, field2…) → this will pull up the biggest value from those fields
When you want to calculate the AVERAGE from several fields
AVERAGE(field1, field2…) → this will pull up the average from those fields
When you want to calculate the SQUARE ROOT
SQRT(value) → this will give you the square root value