Home belajar komputer cileungsi cileungsi komputer kursus komputer di cileungsi ms office Office Latihan Left Mid Right dan if left

Latihan Left Mid Right dan if left

Read

Berikut latihannya :

Rumus :

Left :

=LEFT(B3;3)

Mid :

=MID(B3;4;4)

Right :

=RIGHT(B3;3)

Kode Cabang :

=IF(LEFT(B3;3)="077";"Harvest 1";IF(LEFT(B3;3)="078";"Harvest 2";IF(LEFT(B3;3)="079";"Metland";"Duta")))

Tahun Masuk :

=D3

Nomor Urut :

=E3

Terimakasih

No comments:

Subscribe to: Post Comments ( Atom )