Hai Alfan; Coba begini:
=IF(OR(AND(C2="DES",A2<3.5),AND(C2="DBS",A2<18),AND(C2="DCS",A2<24)),"OK","NOK") Copas kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: Alfan Atas Pujianto To: [email protected] Sent: Thursday, April 03, 2014 12:20 PM Subject: [belajar-excel] Mohon bantuan penggunaan rumus IF [1 Attachment] Dear Rekan, Mohon bantuan penggunaan formula yang pas untuk kolom D sesuai dg Data terlampir. mohon maaf newbie. Tks. Alfan
