Multi if statement

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

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

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.