I have 8 conditions I need to string together, if all are met the formula should return "yes" if anything any condition is false, the formula should return "". I have tried nesting If/ and statements a number of ways, but since they all need to work together I am coming up #unparsable with each iteration.
=IF(AND([Contract Signed]@row="YES",AND([Amount Owed]@row<=0,AND([Term 2 Complete?]@row="YES",AND([1st Rental Hours]@row<>"",AND([2nd Harvest Rent Hours Needed/Provided]@row="",AND([3rd Harvest Rent Hours Needed/Provided]@row="",AND([4th Harvest Rent Hours Needed/Provided]@row="",[5th Harvest Rent Hours Needed/Provided]@row<>""))))))),”YES",””)