Excel question

I scoured the Internet and can’t find exactly what I’m looking for, so I’m holding my hat in my hand and asking for help.


I have a spreadsheet set up for each of my classes for assignments and grades. I have a key with a range of numbers that corresponds to a letter grade. What I’d like to do is add a column that automatically connects the numerical grade for each student with the key and inserts the letter grade automatically.



I’m thinking it will take some kind of if . . . then statements, but not sure where to start.


Thanks for any help you can give me.

 

Bitsy, check our PMs. I built a sample spreadsheet you can download at a link I sent you. The key to your problem is vlookup. The lookup values in the table must always be kept in ascending order. Look at the formulae in the sheet and let me know if you have other questions.

 

Thank you! Thank you :D