Trying to figure out how to make this formula work!

Hi there,

I have a long formula in my spreadsheet that simply outputs "YES" or "NO" based on whether other cells in the same sheet have specific text in them. Here is the formula:

=IF(AND(L4="No Action Required", L5="No Action Required", L6="No Action Required", L7="No Action Required", L8="No Action Required", L9="No Action Required", L10="No Action Required", L11="No Action Required", L12="No Action Required", L13="No Action Required", L14="No Action Required", L15="No Action Required", L16="No Action Required", L17="No Action Required", L18="No Action Required"), "NO", "YES")

What I want to do however, and what I've been trying to figure out but can't, is how to include an OR function in this formula. Say I want my formula to be checking for EITHER "No Action Required" OR "Waiting for Purchase Order" in ONLY cells L5, L6 and L7, how would I include that in this formula?

If I understand correctly:

Formula:

Please Login or Register  to view this content.

AND(L4="No Action Required", OR( L5="No Action Required", L5="Waiting for Purchase Order" ), OR( L6="No Action Required", L6="Waiting for Purchase Order"), OR( L7="No Action Required", L7="Waiting for Purchase Order"), L8="No Action Required", L9="No Action Required", L10="No Action Required", L11="No Action Required", L12="No Action Required", L13="No Action Required", L14="No Action Required", L15="No Action Required", L16="No Action Required", L17="No Action Required", L18="No Action Required")

Hi,

Try

Formula:

Please Login or Register  to view this content.

Incidentally you could probaby simplify that formula by using a

Formula:

Please Login or Register  to view this content.

and with a little thought depending on whether Waiting for PO is only possible in L6:L7 you could incorporate that in a COUNTIF