IF(AND( and IF(OR(

AlexandriaJ13

Hi All!

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! 

Paul Newcome

Try separating each portion out. It makes it easier (sometimes) to just write it out exactly how you would in regular sentence structure.

 

=IF(

 

AND([Resolution Method]3 = "ClinOps F/U",

 

OR([ClinOps Resolution Description]3 = "", [Additional ClinOps F/U Needed?]3 = "Y")

 

, "Yes", "")

.

Gives you:

=IF(AND([Resolution Method]3 = "ClinOps F/U", OR([ClinOps Resolution Description]3 = "", [Additional ClinOps F/U Needed?]3 = "Y"), "Yes", "")