Re: ]] XL-mania [[ Mengetahui Data Suspect

 

Secara sederhana Langkahnya:

1. Buat rumus untuk kode Cust Type yang seharusnya berdasarkan Nomor Pemilik : =IF(or(B3=886,B3=896),"A","B")
   
2. Bandingkan hasil pada rumus di atas dengan data di kolom C. Kalau sama, berarti sesuai, kalau tidak sama berarti suspect. Rumus akhir: =IF(C3=IF(or(B3=886,B3=896),"A","B"),"Sesuai","Suspect")
   
3. Enter
   

 

====== Haeruddin ======

---

From: Munawar <am.munawar@cimbniaga.co.id>
To: XL-mania@yahoogroups.com
Sent: Friday, December 23, 2011 11:09 AM
Subject: ]] XL-mania [[ Mengetahui Data Suspect

 

Dear Pakar Excel,

 

Mohon bantuannya untuk mencari formula dengan kasus yang simple dimana dalam file terlampir terdapat 2 kolom. Yang saya inginkan adalah pada kolom HASIL dibuat formula dimana untuk Gol Pemilik 886 dan 896 pada Cust Type adalah A jika selain dari 2 Gol Pemilik tersebut maka harusnya B.

 

Pada kolom HASIL adalah SESUAI jika Gol Pemilik dan Cust Type sudah benar dan SUSPECT jika Gol Pemilik tidak sesuai.

 

 

Regards,

AM. MUNAWAR

 

---

Privileged/confidential information may be contained in this message. If you are not the named recipient or addressee, you are hereby notified that any use review, disclosure or copying of the contents herein is strictly prohibited. In such a case, kindly discard all its contents and notify sender accordingly regarding such unauthorized disclosure or transmission by email. Opinions, conclusions, statements and other information in this message that do not relate to the official business of CIMB Group shall be understood as neither given or endorsed by it. The contents herein are meant strictly for the use of the named recipient or addressee of CIMB Group. No assumption of responsibility or liability whatsoever is undertaken by CIMB Group in respect of prohibited and unauthorised use by any other person.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 61

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| ayooo... coba cari XL-mania di linkedin.com                       |
| momods kebanyakan e-mail :(... unread di kantor 6 ribu lebih :(   |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau...  |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___