In need a formula IF column D is not blank AND column G OR column I OR column J is blank THEN "Pending"
IF column D is not blank AND column G OR column I OR column J is not blank THEN "Closed"
I have tried COUNTIFS, IFS, and can't get this to work. I don't know what I am missing.
Each column is a DATE as well. I was thinking If DATEVALUE like whatever the date is then yada yada, but I can't get this rationale to work in excel AT ALL. I'm at a lost.
Solved by A. L. in 15 mins