Gimana ya caranya menggunakan fungsi if dan(right, left atau mid)kayak
di Microsoft Excel.
Misalnya mencari Jenis Barang berdasarkan kode seperti dibawah ini :

Kode Barang     Jenis Barang    
A       Polpen  
B       Buku    
C       Pensil  

Nama Pembeli    Kode barang     Jenis barang    
Somebody        B2004           
Nobody  A2004           
Bodyne Asyik    C2005           

Gimana ya rumus untuk mengisi Jensi Barang..?

Thank Before.
Jack not The Jak but Liverpudlian
9632100029


[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Give at-risk students the materials they need to succeed at DonorsChoose.org!
http://us.click.yahoo.com/Z1lQfA/LpQLAA/HwKMAA/x3XolB/TM
--------------------------------------------------------------------~-> 

================> HAPUS IKLAN DIATAS DAN FOOTER INI JIKA ME-REPLY 
<================
Posting   : [email protected]
Archive   : http://www.mail-archive.com/[email protected]/
                www.mitek.unibraw.ac.id || himamitek.brawijaya.ac.id
************************************************************************************
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/mitek/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Kirim email ke