Forum Discussion

WilliamR465's avatar
WilliamR465
Copper Contributor
Oct 15, 2024

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...
excel
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Oct 15, 2024

WilliamR465 

I would use SWITCH for this because the logic reads easier:

=SWITCH(
    F2,
    "less than high school", 1,
    "high school", 2,
    "associates", 3,
    "bachelors", 4,
    "masters", 5,
    "more than masters", 6,
    "None"
)

Resources