If and formula

[apgmin]

What should be the formula for the following:

If cell a1 is not empty then

check cell b1, c1 and d1

only if all the above 3 cells b1, c1 and d1 are "yes"

then the result should be "ok"

If any of the above 3 cells b1, c1 and d1 are empty or anything other than yes then the result should be "rejected"

 

[steve the fish]

This will work:

=IF(AND(A1<>"",COUNTIF(B1:D1,"yes")=3),"ok","rejected")

 

[apgmin]

Sir, only if the cell a1 is not empty should the results come or else it should be blank

 

[Special-K99]

Steve's solution is correct based on your description of the problem.

So just change "rejected" to "" in Steve's solution

Simple.

 

[steve the fish]

Like this?

=IF(A1="","",IF(COUNTIF(B1:D1,"yes")=3,"ok","rejected"))

 

[apgmin]

Now can you please help with the following in addition to the above

cells e1 to j1 should not be empty if any of these cells are empty then also the message should be rejected

 

[steve the fish]

=IF(A1="","",IF(OR(COUNTIF(B1:D1,"yes")<>3,COUNTIF(E1:J1,"")),"rejected","ok"))