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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks