My IF nesting formula is not working

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!