Formula for =IF in
Microsoft Excel
Gred
baru kementerian pendidikan Jan 2015:
=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")))))
=IF(F2=1,”Lepas”,IF(F2=2,”Kandas”,IF(F2=3,”Tarik
Diri”,”Error”)))
=IF(AND(0<=D2,D2<=19),"E",IF(AND(20<=D2,D2<=39),"D",IF(AND(40<=D2,D2<=59),"C",IF(AND(60<=D2,D2<=79),"B",IF(AND(80<=D2,D2<=100),"A","TIADA")))))
