Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Multi if statement

Topic Labels: Formulas
Solved
Jump to Solution
493 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone!

Trying to figure out the best way to do perform this formula.

Column Name: Invoice Status

Formula rules within column:

If “payments” column is filled, and “balance” column = zero show “Paid”

If “payments” column is empty, show “Unpaid”

If “payments” column is filled, but “balance” column is greater than zero, show “Partially Paid”

All help is much appreciated!!

1 Solution

Accepted Solutions

Actually, I figured it out!!

Here is the formula I used incase anyone else needs something similar!

IF(Payments,IF(Balance > 0,“Partially Paid”,“Paid”),“Not Paid”)

See Solution in Thread

1 Reply 1

Actually, I figured it out!!

Here is the formula I used incase anyone else needs something similar!

IF(Payments,IF(Balance > 0,“Partially Paid”,“Paid”),“Not Paid”)