Latihan Fungsi String (LEFT, RIGHT, MID)

SOAL

1. MENCARI PENERBIT

=IF(LEFT(B3,2)="AL","Airlangga",IF(LEFT(B3,2)="AO","Andi Offset",IF(LEFT(B3,2)="BA","Binarupa Aksara",IF(LEFT(B3,2)="BP","Balai Pustaka",IF(LEFT(B3,2)="EL","Elexmedia",IF(LEFT(B3,2)="GA","Gunung Agung",IF(LEFT(B3,2)="GM","Griya Media",IF(LEFT(B3,2)="GR","Gramedia",IF(LEFT(B3,2)="MI","Mizan",IF(LEFT(B3,2)="SE","Salemba Empat"))))))))))

2. MENCARI TAHUN TERBIT

=MID(B3,5,4)

3. MENCARI JENIS BUKU

=IF(MID(B3,3,2)="01","POLITIK",IF(MID(B3,3,2)="02","EKONOMI",IF(MID(B3,3,2)="03","SOSIAL",IF(MID(B3,3,2)="04","BUDAYA",IF(MID(B3,3,2)="05","HUKUM",IF(MID(B3,3,2)="06","AGAMA",IF(MID(B3,3,2)="07","MUSIK",IF(MID(B3,3,2)="08","OLAH RAGA",IF(MID(B3,3,2)="09","SEJARAH",IF(MID(B3,3,2)="10","TEKNIK",IF(MID(B3,3,2)="11","BAHASA")))))))))))

4. MENCARI HARGA BUKU

=IF(RIGHT(B3,1)="A",67800,IF(RIGHT(B3,1)="B",60200,IF(RIGHT(B3,1)="C",58600,IF(RIGHT(B3,1)="D",53000,IF(RIGHT(B3,1)="E",48400,IF(RIGHT(B3,1)="F",43800,IF(RIGHT(B3,1)="G",39200,IF(RIGHT(B3,1)="H",34600,IF(RIGHT(B3,1)="I",30000,IF(RIGHT(B3,1)="J",25400))))))))))

5. MENCAARI DISKON

=IF(C3="Airlangga",F3*10%,IF(C3="Gunung Agung",F3*15%,IF(C3="Balai Pustaka",F3*20%,0)))

6. MENCARI HARGA BARU

=F3-G3