I have a problem creating a formula for my sheets. I want Google Spreadsheets to put either Yes or No in a specific cell depending on the values in other cell. In other words I want it to put Yes when all the cells between B and P have values and put No when cells between B and P are not complete, even one empty cell is not acceptable.

How can I create such a formula?

  • What now, Google docs or Microsoft Excel?
    – nixda
    Commented Nov 22, 2014 at 15:19

1 Answer 1


Cell A2: =IF(COUNTIF(B2:P2,"<>")=COLUMNS(B2:P2),"Yes","No") fill down to get it into the rows below.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.