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", …