IF(AND( and IF(OR(
I feel like I have been reviewing every community post about the IF(AND and IF(OR statements within a function but still can't seem to figure out what I am doing wrong.
=IF(AND([Resolution Method]3 = "ClinOps F/U", [ClinOps Resolution Description]3 = "", IF(OR([Additional ClinOps F/U Needed?]3 = "Y", "Yes", ""))))
where if Resolution Method is ClinOps F/U and the ClinOps Description is blank OR the Additional ClinOps F/U is marked "Y" show "Yes" in the cell.
I hope someone has a simple solution because I feel like I have tried it all and it has to be something silly.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!