menerapkan ilmu dari Mr Kid
="Produk "&LOOKUP( SUMPRODUCT( (B3:J3<>"")*10^(9-{1\2\3\4\5\6\7\8\9}) );
{0\100000000\110000000\111000000\111100000\111110000\111111000\111111100\111111110\111111111};
{1\2\3\4\4\5\6\7\8\9} )
semoga sesuai harapan
Pada Selasa, 13 Mei 2014 13:41, "'Mr. Kid' [email protected] [belajar-excel]"
<[email protected]> menulis:
Hai Satriyo,
Pakai Index Match (lookup ke segala arah) saja ya...
Wassalam,
Kid.
2014-05-13 12:01 GMT+07:00 satriyo bekti wibowo [email protected]
[belajar-excel] <[email protected]>:
>
>Para Master Excell yth.
>
>
>Mohon bantuannya untuk penyelesaian yg "mungkin" menggunakan formula IF
>bertingkat.file saya attach
>
>
>Terima kasih atas bantuan para Master Excell..
>
>
>Salam
>
>
>Satriyo
>
>
>
>
>-don't think out of the box, just break the box and think freely-
>
>
>
>________________________________
>
>From: "'[email protected]' [email protected] [belajar-excel]"
><[email protected]>
>To: [email protected]
>Sent: Monday, May 12, 2014 4:01 PM
>Subject: Bls: [belajar-excel] logika if [1 Attachment]
>
>
>
>
>Coba liat gambar dah, dr td w kirim kepotong molo...
>Harap mklum y dr hp neh...
>Hehehe....
>
>
>
>________________________________
> From: '[email protected]' [email protected] [belajar-excel]
> <[email protected]>;
>To: <[email protected]>;
>Subject: Bls: [belajar-excel] logika if
>Sent: Mon, May 12, 2014 5:01:07 AM
>
>
>
>Lah tu function ngapa jd ilang2an...hedeh...
>´=if(and(a2 "",b2 "",b2 ""),"confirm",if(and(a2 ""),"tutup",""))))
>Dikirim dari Yahoo Mail pada Android
>
>
>
>________________________________
> From: '[email protected]' [email protected] [belajar-excel]
> <[email protected]>;
>To: [email protected] <[email protected]>;
>Subject: Bls: [belajar-excel] logika if
>Sent: Mon, May 12, 2014 3:13:23 AM
>
>
>
>Asumsi "result" berada pada cell d1 maka penulisan rumus pada cell d2
>=if(and(a2 "",b2 "",b2 ""),"confirm",if(and(a2 ""),"tutup","")
>Bisa langsung cubee yaw... :)
>Dikirim dari Yahoo Mail pada Android
>
>
>
>________________________________
> From: 'Muhammad Iqbal' [email protected] [belajar-excel]
> <[email protected]>;
>To: <[email protected]>;
>Subject: [belajar-excel] logika if
>Sent: Sun, May 11, 2014 3:48:15 AM
>
>
>
>Dear be exceler,
>Mohon bantuan untu case seperti berikut ini
>
>A B C result
>text buka
>text text titip
>text text text confirm
>text text Tutup
>
>Bagai mana rumusan yang bisa saya terapkan bila kolom “result”
ber logika,
>Jika kolom A berisi data, maka tulislah “Buka”
>Jika kolom A dan B berisi dana , maka tulis “titip
>Jika kolom A dan C berisi data, maka tulis “tutup”
>Jika kolom A, B dan C berisi data, maka tulis “confirm”
>
>
>Regard
>Muhammad Iqbal
>
>
