Try this,
Formula:
=IF(AND(A1>0,A1<70),"Diploma",IF(AND(A1>=70,A1<80),"Bronze",IF(AND(A1>=80,A1<90),"Silver",IF(A1>=90,"Gold with Distinction",""))))
Try this,
Formula:
=IF(AND(A1>0,A1<70),"Diploma",IF(AND(A1>=70,A1<80),"Bronze",IF(AND(A1>=80,A1<90),"Silver",IF(A1>=90,"Gold with Distinction",""))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks