Using IF Statement to return three possible solutions

[maddogg126]

I am trying to use if statement to return three possible returns. I am using =IF(CountIf(S6:S25,"No")>0, "No", "Yes") to return the value as Yes if all the lookups have Yes or No if there is both Yes and No. However, if there is nothing I would like it to return a blank cell. The formula works so far, but I am struggling with the blank return.

 

[Scott Huish]

=IF(COUNTA(S6:S25),IF(COUNTIF(S6:S25,"No"),"No","Yes"),"")

 

[maddogg126]

=IF(COUNTA(S6:S25),IF(COUNTIF(S6:S25,"No"),"No","Yes"),"")

Thank you Scott! I forgot to mention that the range of cells that are being used are being pulled from another sheet so there is a formula in the cell ('2416'!$F$17). The formula provided returns 'Yes' when there is no Yes or No indicated.

 

[Scott Huish]

=IF(SUM(LEN(S6:S25)),IF(COUNTIF(S6:S25,"No"),"No","Yes"),"")

 

[maddogg126]

=IF(SUM(LEN(S6:S25)),IF(COUNTIF(S6:S25,"No"),"No","Yes"),"")

I am still getting the same results - below are some screen shots - again thank you for your help.

 

[Scott Huish]

What value are you returning if it's "blank"

 

[maddogg126]

Yes it would be a zero

 

[maddogg126]

If I delete the cell referencing another sheet cell, it returns a blank. But when the reference cell is in there, it gives Yes.