Formula to check if a cell contains "No" or isblank
This is probably so simple but I am struggling with my if and isblank, or maybe I don't need isblank and need just "" empty quotes. The Column title is "Added to CRM" and it can contain Yes, No, Revised or blank.
I would like to check a cell and if it contains either the word "No" or is blank return a phrase like "Open". If it contains any other word I don't care.
Help! Thank you.
Help Article Resources
Check out the Formula Handbook template!