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