I'm trying to figure out what the function or formula might be if I wanted a cell to display a letter if an adjacent cell displayed a certain number. For instance, I'm a teacher and I want a column of cells to behave according to the grade percentage of an adjacent cell. An example would be - If Cell A2 is less than 89.5, or equal to 79.5 display a "B". But I'd also like that cell to display a "C" if it were less than 79.5 or equal to 69.5. I hope this wasn't confusing. Look forward to your responses!