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 <[email protected]>
To: [email protected]
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.
