1. I have a spreadsheet that is tracking orders and a column gives the status: Ordered, ordering, received, receiving, denied, rejected, etc..... I need an "if" formula in column "M" that is true if column "E" is ordered, ordering, receiving, or received.