Looking for IF function with 2 conditions

[kian82]

Hi,

I am trying to get a function to work that basically checks if 2 conditions are met. I am using the following formuling formula but it does not seem to work:
=IF((AND(COUNTIF(S3:V3,"Yes")>0,E3="Yes")),"TRUE","FALSE")

The formula needs to check in Range S3:V3 if there is at least one value = "Yes". Should the value "Yes" be available then it needs to be made sure that E3="Yes". Should this condition be met then the value "TRUE" should be returned. The same should be done, if "AND(COUNTIF(S3:V3,"Yes")=0,E3="No")"

Any idea how I can combine both tests?

[mcmahobt]

Would a nested IF statement work?

=IF((AND(COUNTIF(S3:V3,"Yes")>0,E3="Yes")),TRUE,IF(AND(COUNTIF(S3:V3,"Yes")=0,E3="No"),TRUE,FALSE))

[JohnTopley]

Try

=IF(OR(AND(COUNTIF(S3:V3,"Yes")>0,E3="Yes"),AND(COUNTIF(S3:V3,"Yes")=0,E3="No")),"TRUE","FALSE")