Tuesday, November 7, 2017

formula if in excel

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")))))

No comments:

Post a Comment