LKS 12

Jenis Apartemen =VLOOKUP(VALUE(MID(B7,2,1)),$A$31:$C$33,2,0)
Developer =HLOOKUP(LEFT(B7,1),$G$30:$I$31,2,0)
Jumlah Penjualan =VALUE(MID(B7,2,2))
Harga Apartemen =VLOOKUP(VALUE(MID(B7,2,1)),$A$31:$C$33,3,0)
Bonus =IF(F7>25,6%*G7*F7,IF(F7<12,3.5,IF(F7>=12,3.5%*G7*F7)))
Komisi Tetap =VALUE(G7/5000000)*HLOOKUP(E7,$G$31:$I$32,2,0)
Jumlah Pendapaatan =SUM(H7:I7)