How would it know that if its greater than 80 but less that 90 to render a B and when its just greater than 80 (say 93) to render an A. I've tried =IF(AND(... but what I can't figure out is how to do multiple sections in one function. Like if B2 is >=90, then A, if <90 but >=80, then B, if <80 but >=70, then C, if <70, then D. That's what I want it to do but I don't know how to talk computer for it.