langsung menebak SUMBER penyebabnya (nilai di kolom A)
=IF(A3="","",D3+E3)

  ----- Original Message ----- 
  From: siti Vi 
  To: [email protected] 
  Sent: Sunday, December 20, 2009 12:00 PM
  Subject: Re: [belajar-excel] (unknown)


  =SUM(D3:E3)
  =IF(ISERR(D3+E3),"",D3+E3)
  =IF(IBLANK(E3),"",D3+E3)



  ----- Original Message ----- 
  From: Sandra Yudha 
  To: belajar excel 
  Sent: Sunday, December 20, 2009 11:09 AM
  Subject: [belajar-excel] (unknown)

  Salam semua 
  langsung aja nih, bagaimana menghilangkan hasil rumus #value!, 
  ataukah ada rumus yang lebih oke. contoh kasus spt yg terlampir
  Terima kasih 
  Yudha

Kirim email ke