What formula to use?

Brass Contributor

hi

 

I like to check 

how to indicate in Col V, Yes or NO

yes if W , X and Y no value
No if W, X and Y has date or text in it.

 

Thank you

 

bbsin_0-1681987623882.png

 

1 Reply

@bbsin 

In V3:

=IF(AND(W3:Y3=""), "Yes", "No")

Fill down.