Hello, I need help writing an "IF" statement.
Cell C2 contains one of five possible responses: Exceptional, Highly Effective, Solid Performance, Needs Improvement, Not Effective
In cell C3, I would like to assign a numerical answer based on C2. For example: If C2 equals Exceptional I would...