Nested IF AND OR
I am trying to get a formula for a check box that combines an if AND with an If OR. I have a column labeled Rental Billed that is a check box. There is another column that has multiple status options from a drop down. I want the formula to return a 1,0 if the rental billed column @row is not checked AND the Status is set to either "Complete" OR "Canceled"
Formula I cannot get to work is as follows:
This returns an "Incorrect Argument set" error. I am sure I am missing something simple, and suspect it has to do with the AND / OR, but any help would be appreciated.