=SUM(D3,E3) =SUM(D3)+E3 =IF(D3="","",D3+E3) =IF(LEN(D3)>0,SUM(D3,E3),"")
lho kok jml karakter dlm formula semaNGkin panjang ? ( ndak main la yauw.. ) ----- Original Message ----- From: anton suryadi Sent: Sunday, December 20, 2009 12:49 PM =N(D3)+E3 >semoga bermanfaat From: Sandra Yudha <[email protected]> To: belajar excel <[email protected]> Sent: Sun, December 20, 2009 11:09:15 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
