=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",
IF(RIGHT(D9,2)="13","LG",
IF(RIGHT(D9,2)="14","Toshiba",
IF(RIGHT(D9,2)="15","Samsung","Merek Tidak Dikenal")))))
nnn
=IF(H9>=1000000, H9*25%,
IF(H9>=800000, H9*20%,
IF(H9>=500000, H9*15%,
IF(H9>=300000, H9*10%,
IF(H9>=200000, H9*5%,
0)))))
=IF(AND(H9>=2000000, I9>=1000000), "Tas Keren",
IF(AND(H9>=1000000, I9>=500000), "Payung",
IF(AND(H9<1000000, I9<100000), "Gelas", "Tidak Ada Bonus")))
=IF(AND(H9>=2000000, I9>=1000000), "Tas Keren",
IF(AND(H9>=1000000, I9>=500000), "Payung",
IF(AND(H9<1000000, I9<100000), "Gelas", "Tidak Ada Bonus")))
=IF(AND(H9>=2000000, I9>=1000000), "Tas Keren",
IF(AND(H9>=1000000, I9>=500000), "Payung",
IF(AND(H9<1000000, I9<100000), "Gelas", "Tidak Ada Bonus")))
=IF(OR(H9>=2000000, I9>=1000000), "Tas Keren",
IF(OR(H9>=1000000, I9>=500000), "Payung",
IF(OR(H9<1000000, I9<100000), "Gelas", "Tidak Ada Bonus")))
=VLOOKUP(LEFT(D9,2), L15:N19, 3, FALSE) & " - " & VLOOKUP(RIGHT(D9,2), S14:W15, 2, FALSE)
Postingan