Multi if statement

[Anonymous]

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!!

[Anonymous · Accepted solution]

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”)