Using intervals in excel forumals?

Question

Hi there!

So I'm making a spreadsheet to help me keep up with my class grades for uni, and I've run into a bit of an issue. This isn't necessarily stopping me, it could just make things much more efficient.

So, I'm trying to have a cell, let's say A2, read a number in A1 and based off that number spit out a string as a letter, such as "A", "B", "C" and so forth. I've experimented with the logical IF functions and using OR and AND with it, but it's not as efficient due to the lack of (my knowledge of) intervals. I'm calculating my numerical grade to the hundredths place, so if I use IF((OR(A2=90, A2=91, . . .to 100)), "String") it only covers 91, 92, 93 and so on. I was hoping there's a way to cover every number from 90-100 including all the decimals in between. I've been trying to find some form of interval notation or something like that but either I'm not looking hard enough or it's not that common of an issue. Any help would be appreciated!

(Not sure if this is useful, but from the information tab:)

I'm running Version 2002 (Build 12527.20278)

Answer 1

For example:

=LOOKUP(A2,{0,60,70,80,90},{"F","D","C","B","A"})