I am trying to create a column that will convert a number score into a letter
score based on a range. For instance, if the cell has 720 in it then I want
an A to print in another cell. If the number is 600 then a C should print. I
can get it to print using an IF statement so long as there is only one
option. Any ideas for multiple options? I tried VLOOKUP but that doesn't work.