I've been trying to put together a bit of code to result in a yes or no.

Basically if all cells result in Yes then it outputs yes if not No.

I have this working exactly how i need it to:

=IF(AND(Y4="Yes",V4="Yes",S4="Yes",P4="Yes",M4="Yes",J4="Yes",G4="Yes",D4="Yes"),"Yes", "No")

But in some cases V4 can be blank and even if it's blank I'd like it to stil output as "Yes". How can i do this?

Many thanks!