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
Tanya.xlsx
Description: MS-Excel 2007 spreadsheet
