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.