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?
Bookmarks