Dear Alfan,
Dikolom C2, coba ketikkan rumus berikut : =IF(AND(A2="DC",B2<=24),"OK",IF(AND(A2="DB",B2<=4),"OK",IF(AND(A2="DE",B2<=4),"OK","NOT OK"))) Kemudian paste kebawah From: [email protected] [mailto:[email protected]] On Behalf Of Alfan Atas Pujianto Sent: Friday, November 09, 2012 16:10 PM To: [email protected] Subject: [belajar-excel] Help, fungsi IF ganda Dear Exceller Mohon bantuan formula untuk fungsi if yang beda ketentuan. Regards
<<image001.jpg>>
<<image002.jpg>>
