Good day all,

I need to return the word "CLOSED" if one of 2 cells contains a specific word, formula so far is =IF(E3="NCAR",IF(AN3="Acceptable","CLOSED","")) but this only returns "CLOSED" if both criteria are met not just one? Help

Sorry but I can't see the woods for all these damn trees!
Marco