If Statement issue

[xsmurf]

Hi Experts,

I have a question regarding an IF-Statement.

If have 3 cells (U3 / U4 / U5) and these cells retrieve information from a different workbook, this work perfect.
My goal is to give a value in cell V3 depending on the information in those 3 cells.
There are only 3 options possible in cell U3 / U4 / U5, which are "Yes", "No" or blank/empty.
The IF statement in cell V3 should do the following:
- If all the values are "No", cell V3 should say "No"
- If there is a "Yes" in any of the 3 cells, cell V3 should say "Yes"

The IF-statement that I have is doing that without any issues, however when 1 of cells is empty cell V3 is empty.
This is where I have my problem.

How can I modify the IF-statement that it will ignore the blanks but will still give the proper answer?

My code:

=IF(AND(U3:U5<="No"),"No",IF(OR(U3:U5="Yes"),"Yes",""))

Thank you for the help

 

[Joe4]

This statement makes no sense to Excel:

U3:U5="Yes"

If you want to check to see if all three cells are equal to "Yes", use:

COUNTIF(U3:U5,"Yes")=3

If you want to check to see if ANY of the cells are equal to "Yes", you can use:

COUNTIF(U3:U5,"Yes")>0

Armed with this new knowledge, I will leave it up to you to update those parts of your formulas.
If you still have issues, post your updated formula attempt here.

 

[Fluff]

How about

=IF(COUNTIFS(U3:U5,"Yes"),"Yes",IF(COUNTIFS(U3:U5,"No")=3,"No",""))

 

[xsmurf]

I had to adjust the code a little, but this one works perfect
thank you @Fluff & @Joe4

=IF(COUNTIFS(U3:U5,"Yes"),"Yes",IF(COUNTIFS(U3:U5,"No")>=1,"No",""))

 

[Fluff]

Glad we could help & thanks for the feedback.