Dear Gilang

Trims atas Bantuannya,

Regard
alfan

--- Pada Jum, 9/11/12, Gilang Sedar <[email protected]> menulis:

Dari: Gilang Sedar <[email protected]>
Judul: RE: [belajar-excel] Help, fungsi IF ganda
Kepada: [email protected]
Tanggal: Jumat, 9 November, 2012, 10:11 AM
















 



  


    
      
      
      







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 
  
 






 










    
     

    
    






  








Kirim email ke