How can I do If then elseif in Formula

[gettinthere]

I am trying to come up with a formula that will check if values in the range A2:A25 contains either Yes or No or Both (Yes and No) and then in A1 display

No if range only contains cells with No
Yes if range only contains cells with Yes
Both if the cells contain both No and Yes

Can someone please help me with the formula, I know how to check if it range contains a "yes" or a "no" but am not sure how to check for the condition when some cells have Yes and some Cells have No. Some of the cells might be blank in the range as well.

Thanks

[Fotis1991]

Try this.

=IF(AND(COUNTIF(A2:A25,"NO"),COUNTIF(A2:A25,"YES")=0),"NO",IF(AND(COUNTIF(A2:A25,"YES"),COUNTIF(A2:A25,"NO")=0),"YES","BOTH"))

[gettinthere]

Fotis. Thank you so much for such a quick reply. It is perfect and it works !!

[Fotis1991]

You are welcome and thanks for the feedback.