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<https://id.overview.mail.yahoo.com/mobile/?.src=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<https://id.overview.mail.yahoo.com/mobile/?.src=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* > > > >
re-Tanya.xlsx
Description: MS-Excel 2007 spreadsheet
