Pak Suhendar;

Coba begini:

Soal no.1 (pake if-if-an) 
=IF(F18<70,"non",IF(F18<=100,"A",IF(F18<=150,"B",IF(F18<=200,"C",IF(F18<=300,"D","E")))))
Copas kebawah

Soal no.2 
=COUNTIF($G$18:$G$27,C6)
Copas kebawah




Wassalam

~ Bagus ~



  ----- Original Message ----- 
  From: Suhendra St [email protected] [belajar-excel] 
  To: [email protected] 
  Sent: Wednesday, November 12, 2014 8:51 AM
  Subject: [belajar-excel] revisi soal menentukan jumlah berdasarkan kreteria 
[1 Attachment]


    

  Maaf yg kemarin salah, berikut kasus yang benar



  mohon bantuan nya bagaimana cara formula untuk membuat terhadap kasus 
dimaksud (terlampir)


  thanks sebelumnya
  su




  

Kirim email ke