I have been struggling trying to create a formula to return TEXT based on multiple criteria.
I have 4 columns for dates titled “Promise Date”, “Delivery Date”, “Cancelled Date” and “Return Date (Columns E, F, G & H). In column “I” (titled “Delivery Status”) I wanted to return text based on:
If only Promise Date entered then returns “Pending”
If Promise Date and Delivery Date are entered, then returns “Received”
If Promise Date and Cancelled Date are entered, then returns “Cancelled"
If Promise Date, Delivery Date, and Return Date are entered then returns “Returned”
If Columns E to H do not have any data, then Column I returns a blank cell
Note: I typed in results I want in Column “I”
See attached
Bookmarks