Forum Discussion
Nested if functions
Hi guys, im trying to do a nested if function revolving around this : =IF(F2="less than high school",1, IF(F2="high school",2,IF(F2="associates",3,IF(F2="bachelors",4,IF(F2="masters",5, IF(F2="more t...
Text comparison in Excel is (in most situations) case-sensitive. So if F2 contains High School, the formula won't return 2 since High School is not equal to high school.
Also, an extra space will throw a spanner into the works.
Try this:
=XMATCH(TRIM(LOWER(F2)), {"less than high school", "high school", "associates", "bachelors", "masters", "more than masters"})