Try this,

Formula: copy to clipboard
=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",""))))