Excel Formula Help - IF Formula
Hey guys, hopefully somebody can help me out with an Excel formula.
I need to do multiple If statements within a single formula. So the formula has to check if, for example, cell J2=4, then cell L2=Ontario, if not, then if cell J2=9, then cell L2=Quebec, etc... It needs to check for about 50 different numbers, so J2 has numbers from 1-50.
I need to do multiple If statements within a single formula. So the formula has to check if, for example, cell J2=4, then cell L2=Ontario, if not, then if cell J2=9, then cell L2=Quebec, etc... It needs to check for about 50 different numbers, so J2 has numbers from 1-50.