Pak Syam;

Coba begini:

=IF(SUM(D5:E5)=0,"",IF(E5>=D5,"ok","no"))
atau:
=IF(OR(D5="",E5=""),"",IF(E5>=D5,"ok","no"))


Wassalam

~ Bagus ~



  ----- Original Message ----- 
  From: Sam Mun samkaw...@yahoo.com [belajar-excel] 
  To: belajar-excel@yahoogroups.com 
  Sent: Thursday, September 25, 2014 12:22 PM
  Subject: [belajar-excel] hasil dari formula [1 Attachment]


    

  Yth Para Guru Excel


  Tolong beritahu saya atas problem sebagaimana file contoh  terlampir.


  Terima kasih atas bantuannya.


  Salam


  Syamsaimun

  

Kirim email ke