MENU
    Formula field calculations in Airtable
    • 14 Aug 2024
    • 1 Minute to read
    • Dark
    • PDF

    Formula field calculations in Airtable

    • Dark
    • PDF

    Article summary

    This article covers how to to add, subtract, multiply, and divide using the formula field in Airtable to streamline your team's and organization's work.

    Multiplying in Airtable 

    Multiplying using the formula field

    For example, let's say you'd like to calculate the total wages for a team of hourly staff. You'll need a field to track hours (number field), another to track wages (currency field), and a final field (formula field) to enter as a formula.

    360045339694ScreenShot2019-09-04at81155PM.jpg

    In the {Total Wages} field, this formula is used to calculate the total wages for the day for each employee:

    {Hours Worked} * {Hourly Wage}
    Plain text

    Subtracting in Airtable 

    Subtracting using the formula field

    You can accomplish similar calculations using the same formula structure. To find the difference between wages due and wages paid, you would use a formula like the following:

    {Total Wages Due}-{Total Wages Paid}
    Plain text

    360045339834ScreenShot2019-09-04at81835PM.jpg

    Dividing in Airtable 

    Dividing using the formula field

    In a different scenario, let's say that you're using Airtable to track your freelance project work. You quote a certain number of hours of service you will provide, and want to track your completion towards those hours.

    360046198133ScreenShot2019-09-04at82814PM.jpg

    In {Project Completion}, you would use a formula like the following to calculate your progress:

    {Actual Hours} / {Quoted Hours}
    Plain text

    Adding in Airtable 

    Adding using the formula field  

    You can add multiple fields together by separating them with a + sign. In the example below, several fields are added together to find the final invoice total for a legal department.

    360045340274ScreenShot2019-09-04at83338PM.jpg

    The {Invoice Total}field uses the formula below:

    {Legal Consult} + {Retainer} + {Miscellaneous Fees}
    Plain text

    Adding, subtracting, multiplying, and dividing using one formula in Airtable

    Adding, subtracting, multiplying, and dividing using the formula field

    You can run any number of different functions within the same formula. In the example below, several different factors play into finding the final amount to charge a client on a payment plan:

    • Multiply {Consult: Hours} * {Consult {Rate}

    • Add {Retainer} and {Miscellaneous fees}

    • Subtract {Discounts}

    • Divide everything by {Num. of Payments}

    360046199913ScreenShot2019-09-04at85044PM.jpg

    All of these are built-in to a formula together in {Charge per Payment} using the formula below:

    (
     ({Consult: Rate}*{Consult: Hours})
     + Retainer
     + {Miscellaneous Fees}
     - {Discounts}
    )
     /{Num. of Payments}
    Plain text

    Formatting formula fields in Airtable

    Please consult the information available in this support article to learn more.


    Was this article helpful?