Help

Multi if statement

Topic Labels: Formulas
Solved
Jump to Solution
883 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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