If specific columns have value then put Yes

[foxy_420]

This might be a basic question but I am wondering if there is a formula or macro that can help me out.

This is what I am looking for:

If certain specific cells contain values, then another cell will put a "yes" in it.

Ie.) If Cells A1, B1, C1, D1 have a value in it then cell E1 should say "yes". If one of these cells is blank then E1 should either be blank or say "no".

Currently the formula I have is:

=IF(ISBLANK(A1), IF(ISBLANK(B1), IF(ISBLANK(C1),IF(ISBLANK(D1), "",D1,C1),B1),A1)
(This doesn't work as the error "You’ve entered too many arguments for this function"

=IF(ISBLANK(A1), IF(ISBLANK(B1), IF(ISBLANK(C1), "",C1),B1),A1)
(This formula does work though as it has less arguments)


Please let me know if this is possible. Thank you in advance for your help

[BadlySpelledBuoy]

=IF(COUNTA(A1:D1)<4,"No","Yes")

This may not be suitable if the contents of cells A1:D1 are created via formulas.

[foxy_420]

Thank you very much. What if hypothetically the cells are NOT in succession. Could the Same formula apply?

ie.) A1, B1, D1, E1, J1 have values, then K1 = yes

[BadlySpelledBuoy]

=IF(COUNTA(A1,B1,D1,E1,J1)<5,"No","Yes")

[foxy_420]

Thank you very much. This is exactly what I was hoping for. I will add to your reputation and mark this as solved.

Thanks again

[BadlySpelledBuoy]

Glad to help. Thanks for the rep

BSB.