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?

migrated from superuser.com Nov 23 '14 at 16:07

This question came from our site for computer enthusiasts and power users.

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

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, privacy policy and cookie policy