Postingan
testing
Admin
=IF(A2="sl","Setrika Listrik",
IF(A2="ka","Kipas Angin",
IF(A2="bl","Blender",
IF(A2="kk","Kulkas",
IF(A2="mc","Mesin Cuci","Kode Tidak Dikenal")))))
=IF(LEFT(D9,2)="sl","Setrika Listrik",
IF(LEFT(D9,2)="ka","Kipas Angin",
IF(LEFT(D9,2)="bl","Blender",
IF(LEFT(D9,2)="kk","Kulkas",
IF(LEFT(D9,2)="mc","Mesin Cuci","Kode Tidak Dikenal")))))
=IF(LEFT(D9,2)="sl","Setrika Listrik",
IF(LEFT(D9,2)="ka","Kipas Angin",
IF(LEFT(D9,2)="bl","Blender",
IF(LEFT(D9,2)="kk","Kulkas",
IF(LEFT(D9,2)="mc","Mesin Cuci","Barang Tidak Dikenal")))))
&" - "&
IF(RIGHT(D9,2)="11","National",
IF(RIGHT(D9,2)="12","Philips",
…