| Rumus mencari Merk Mobil: |
|
|
=IF(LEFT(C8,1)="M","MERCY",IF(LEFT(C8,1)="H","HONDA",IF(LEFT(C8,1)="B","BMW","VOLVO")))
|
|
|
|
|
|
| Rumus mencari Tahun Kend: |
|
|
|
|
|
|
| =MID(C8,3,2) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| LAPORAN
KONDISI KENDARAAN |
| JAA SEWA MOBIL |
| Upah sewa
mobil/jam : 200.000 |
|
|
|
|
|
|
|
|
|
|
|
| NO |
NAMA SISWA |
KODE KENDARAAN |
MERK MOBIL |
TAHUN KEND |
JML |
TARIF SEWA |
| YG DISEWA |
| 1 |
YULI |
M-95-SD |
MERCY |
95 |
|
|
| 2 |
FARHAN |
H-97-MB |
HONDA |
97 |
|
|
| 3 |
SUSILO |
B-96-SD |
BMW |
96 |
|
|
| 4 |
ANDREAS |
B-93-SD |
BMW |
93 |
|
|
| 5 |
TATI |
M-95-BS |
MERCY |
95 |
|
|
| 6 |
DANI |
H-97-MB |
HONDA |
97 |
|
|
| 7 |
NUNUNG |
B-97-SD |
BMW |
97 |
|
|
| 8 |
DENI |
H-97-MB |
HONDA |
97 |
|
|
| 9 |
AGUS |
M-93-SD |
MERCY |
93 |
|
|
| 10 |
RITA |
H-95-TR |
HONDA |
95 |
|
|
| 11 |
NANI |
V-94-TR |
VOLVO |
94 |
|
|
|
|
|
|
|
|
|
|
Keterangan: |
|
|
|
|
|
|
1. Untuk mengisi Merk Mobil diambil
digit pertama dari kode Kendaraan |
|
|
M = Mercy H = Honda B = BMW
V = Volvo |
|
|
|
|
2. Tahun kendaraan diisi dengan
ketentuan : diambil dari digit ketiga dan keempat |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | | | | | |
