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

