My IF nesting formula is not working

fcooke

My formula: =IF(AND(Status@row = "Completed", [Remaining Amount]@row = "0"), OR([Payment Status]@row = "Payment", [Payment Status]@row = "Undefined"), "Paid") is not working. I want to show "Paid" if status is completed AND remaining amount is zero but payment status must be either Payment OR Undefined. Formula works but is not considering Remaining amounts= 0. It's displaying Paid when remaining amount has a value Help!!

brianschmidt

No problem. Glad it works for you! It looks like you were just needing to nest the OR function within your AND function.

brianschmidt

It looks like you put your closed parentheses on the AND statement too early. Try this:

=IF(AND(Status@row = "Completed", [Remaining Amount]@row = "0", OR([Payment Status]@row = "Payment", [Payment Status]@row = "Undefined")), "Paid")

Hope this helps!:)

fcooke

OMG, thanks @brianschmidt . I spent hours moving this whole formula around... LOL

brianschmidt

No problem. Glad it works for you! It looks like you were just needing to nest the OR function within your AND function.