Formula Help, please

[Jason_Mitchell]

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”

THANKS!!!

[W_Vann_Hall]

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

IF(
    {Column 3},
    IF(
        {Column 4},
        'Scholarship',
        'Pending'
        ),
    'Complete'
    )

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

If

• {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'.

[Jason_Mitchell]

Dag! That’s awesome - thank you!