2

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?

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

1 Answer 1

2

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

0

Your Answer

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