Terima kasih ya pak atas solusinya, it's work Powered by Telkomsel BlackBerry®
-----Original Message----- From: jkssxls Sudarsono <[email protected]> Sender: [email protected] Date: Fri, 4 Nov 2011 04:23:13 To: Belajar-Excel Yahoo Groups<[email protected]> Reply-To: [email protected] Subject: RE: [belajar-excel] Fungsi IF double alurnya : 1. kondisi yg memenuhi sel D1 dan E1 di tes : IF(AND(D1="",E1=""),0, ..... )2. baru test yg berikutnya , misal D1 : IF(D1<>"",2500, ....) jadi rumus lengkapnya :=IF(AND(D1="",E1=""),0,IF(D1<>"",2500,3000)) dalam hal kondisi di tes , misal1. kosong atau tidak 2. nilai numerik atau bukan maka rumus makin panjang. Tapi untuk sementara sesuai pertanyaa dulu yah... To: [email protected] From: [email protected] Date: Fri, 4 Nov 2011 04:10:08 +0000 Subject: [belajar-excel] Fungsi IF double Dear all Help me dong, kok rumus IF yg saya buat tidak sesuai sprti yg saya inginkan. (See attachment) Salam TinyPowered by Telkomsel BlackBerry®From: [email protected] Date: Fri, 4 Nov 2011 10:53:55 +0700To: <[email protected]>Subject: Best Regards, HARTINI Finance Department PT. BUMA - DWA (P) +62-21-6613636 ext. 33161 (E) [email protected]
