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 than masters”,6,))))))

it shows me 3,4 and 5 but shows a 0 for 1,2 and 6. any ideas on how to fix this?

​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 than masters”,6,)))))) it shows me 3,4 and 5 but shows a 0 for 1,2 and 6. any ideas on how to fix this?  Read More

​