Hi,

If the cells have to match your values then this should work

=IF(C2=2,"C",IF(C2=2.3,"C+",IF(C2=2.7,"B-",IF(C2=3,"B",IF(C2=3.3,"B+",IF(C2=3.7,"A-",IF(C2=4,"A","")))))))

if you meant e.g less that 2.2 = C then let me know

VBA Noob