Panduan untuk edit Google Sheet bagi data daripada Google Form Kuiz
Q2 >>> =ArrayFormula(IF(ISBLANK($C$2:$C),"",$C$2:$C*10&"%"))
R2 >>> =ArrayFormula(IF(ISBLANK($C$2:$C),"",IF($C$2:$C > 5,"LULUS","GAGAL")))
Q2 >>> =ArrayFormula(IF(ISBLANK($C$2:$C),"",$C$2:$C*10&"%"))
R2 >>> =ArrayFormula(IF(ISBLANK($C$2:$C),"",IF($C$2:$C > 5,"LULUS","GAGAL")))