Excel code for mark range (grade)
=IF(AND(0<=E4,E4<=39),"E",IF(AND(40<=E4,E4<=49),"D",IF(AND(50<=E4,E4<=64),"C",IF(AND(60<=E4,E4<=79),"B",IF(AND(80<=E4,E4<=100),"A","TIADA")))))
=IF(AND(0<=E4,E4<=39),"E",IF(AND(40<=E4,E4<=49),"D",IF(AND(50<=E4,E4<=64),"C",IF(AND(60<=E4,E4<=79),"B",IF(AND(80<=E4,E4<=100),"A","TIADA")))))
=IF(AND(0<=F29,F29<=39),"E",IF(AND(40<=F29,F29<=49),"D",IF(AND(50<=F29,F29<=64),"C",IF(AND(60<=F29,F29<=79),"B",IF(AND(80<=F29,F29<=100),"A","TIADA")))))
