Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula Help, please

Topic Labels: Formulas
689 2
Showing results for 
Search instead for 
Did you mean: 

This is for a registration DB

Column 1 - Order Amount (this is a currency format)
Column 2 - Amount Paid (currency format)
Column 3 - Balance Due (formula with 1-2, formated as currency)
Column 4 - Scholarship? (checkbox - if family got a scholarship then all fees are waived and this box is checked)
Column 5 - I want this to say 1 of 3 things: If Column 3 is $0.00, then “Complete”, if Column 3 is anything greater than $0.00 AND Column 4 is not checked, then “Pending”, but it if is checked, then “Scholarship”


2 Replies 2

There are several ways this could be written. This is perhaps the briefest but by no means the most immediately comprehensible:

    {Column 3},
        {Column 4},

This takes advantage of Airtable’s equating of zero values, unchecked check boxes, and Boolean ‘false’. Essentially, it means


  • {Column 3} is not equal to $0.00 and {Column 4} is checked,
    return the word 'Scholarship'.
  • Otherwise, if {Column 3} is not equal to $0.00 and {Column 4} is not checked,
    return the word 'Pending'.
  • Otherwise, if {Column 3} is equal to $0.00,
    return the word 'Complete'.

Dag! That’s awesome - thank you!