Fungsi RIGHT

Fungsi Right

Ø  Fungsi RIGHT digunakan untuk mengambil beberapa karakter Microsoft Excel dari sebelah kanan pada string.

Rumus/ formula dasar dari fungsi RIGHT adalah …..

= RIGHT (String, X) // = RIGHT (alamat sel, X) atau

= RIGHT (String; X) // = RIGHT (alamat sel; X)

Keterangan :

String : kalimat atau string, atau sel yang akan diambil karakternya

X : Jumlah karakter yang diambil dari kanan.

Ø  Bentuk umum penulisan rumus fungsi RIGHT adalah :
=RIGHT(text;num_chars).

Ø  TEXT : adalah referensi yang menyatakan alamat cell yang ingin kita ambil teksnya. Misalnya pada cell B6. Disini juga dapat kita tulis langsung teks yang ingin diambil teksnya, seperti “MICROSOFT” (harus diberi tanda kutip diantara teks tersebut).

=RIGHT(B6;….)
atau
=RIGHT(“MICROSOFT”;….)

Ø  NUM_CHARS : menunjukkan banyaknya karakter yang ingin diambil dari data tersebut. Nilai ini harus berisi dengan angka. Jika num_chars tidak diisi, maka excel akan memberikannya nilai 1.

=RIGHT(B6;4)
atau
=RIGHT(“MICROSOFT”;4)

Soal Microsoft Excel 1 untuk mendapatkan fungsi RIGHT

No	Nama Siswa	Ambil 2 Karakter Di Kanan 2 Karakter
1	Oklisa	sa
2	Farida	da
3	Yaya	ya
4	Ryana	na
5	Ani	ni
6	Rizky	ky
7	Nurhasanah	ah
8	Azizah	ah

Gunakan fungsi RIGHT untuk mengambil 2 karakter dari KANAN

Ø  Langkah – langkah menggunakan Fungsi RIGHT

1.      Buka Microsoft Excel

2.      Buat colom sesuai dengan soal

3.      Masukan rumusnya seperti berikut ini

4.      Hasil dari penggunaan rumus FUngsi RIGHT maka akan sperti dibawah ini :

Soal Microsoft Excel 2 untuk mendapatkan fungsi RIGHT

Data Pengiriman Barang Bulan November

No.	Kode	Tujuan Pemgiriman	Kode Tempat
1	100-550-BPN	Balikpapan	BPN
2	100-551-SMD	Samarinda	SMD
3	100-553-PPU	Penajam Paser Utara	PPU
4	100-601-BJR	Banjar	BJR

Gunakan Fungsi RIGHT untuk mendapatkan “Kode Tempat”

Ø  Langkah – langkah menggunakan Fungsi RIGHT

1.      Buka Microsoft Excel

2.      Tulis semua soal dalam Microsoft Excel

3.      Masukan rumus Fungsi RIGHT seperti di bawah ini

4.      Maka hasil dari penggunaan rumus Fungsi RIGHT  seperti dibawah ini

Lee Hi - 1,2,3,4

English Translation:

Hey.
C’mon now.
I said 1, 2, 3…

Your delusion that I’m still yours ends here.
I’m not that same girl you knew before.
At the sound of morning, the flowers have already bloomed so much.
But why are you still so out of focus?

I’m sick and tired of your hypocrisy.
You lame liar. (Ooh) Will you just back off now?
I think I’m going, going crazy (ooh).
I think I’m going, going crazy (ooh).

Don’t act so miserably and pitifully.
Go disappear far, far away. No, no. Na-na-na-na-na-na.
Don’t cry so pathetically. Just forget everything forever. No, no.

Listen.
Stop worrying about others and just mind your own business.
I don’t need your sympathy or pity. Uh.

I said 1 and 2 and 3, 4 (ooh).
Time will be the one resolving everything.
1 and 2 and 3, 4 (ooh).
Game over. Game over (ooh). Game over.

No matter where you go, no matter how hard you rub your eyes,
another girl like me is so hard to find.
All the boys cry and go like babies at my sexiness and purity.

I’m sick and tired of your hypocrisy.
You lame liar. (Ooh) Will you just back off now?
I think I’m going, going crazy (ooh).
I think I’m going, going crazy (ooh).

Don’t act so miserably and pitifully.
Go disappear far, far away. No, no. Na-na-na-na-na-na.
Don’t cry so pathetically. Just forget everything forever. No, no.

Listen.
Stop worrying about others and just mind your own business.
I don’t need your sympathy or pity. Uh.

I said 1 and 2 and 3, 4 (ooh).
Time will be the one resolving everything.
1 and 2 and 3, 4 (ooh).
Game over. Game over (ooh). Game over.

It hurts so much. I guess I’ve already forgotten you.
Hey baby. Just leave.

I said 1 and 2 and 3, 4 (ooh).
Time will be the one resolving everything.
1 and 2 and 3, 4 (ooh).
Game over. Game over (ooh)
Game over.

1 and 2 and 3, 4
1 and 2 and 3, 4
1 and 2 and 3, 4

Game over
Game over
Game over

Romanized:

Hey
C’mon now
I said 1 2 3

Ajikdo naega ni georaneun
Chakgageun geuman
Yejeonui geuttae naega anya
Achimi barngneun sorie
Kkocheun jeomanchi pyeonneunde
Yeojeonhi jeongsin mot charyeo wae

I’m sick and tired neoui wiseone
Eoseolpeun liar ooh ije jom kkeojyeojullae
I think I’m going going crazy ooh
I think I’m going going crazy ooh

Deo bichamhage guljineun ma
Sarajyeojwo jeo meolli
No no nananananana
Guchahage uljineun ma
Da ijeojwo yeongwonhi no no

Listen
Nam geokjeonghaji malgo neona jal hae
Ni geureon dongjeong ttawin pillyo eobseo uh

I said 1 and 2 and 3 4 ooh
Sigani modeungeol haegyeolhalgeoya
1 and 2 and 3 4 ooh
Game over game over ooh
Game over

Na gateun yeoja eodil gado
Nun ssitgo bwado bogi deumune
Ttaeroneun seksi ttaeron cheongsunhame
Namjadeureun ulgo gane yuchihage

I’m sick and tired neoui wiseone
Eoseolpeun liar ooh jebal jom kkeojyeojullae
I think I’m going going crazy ooh
I think I’m going going crazy ooh

Deo bichamhage guljineun ma
Sarajyeojwo jeo meolli
No no nananananana
Guchahage uljineun ma
Da ijeojwo yeongwonhi no no

Listen
Nam geokjeonghaji malgo neona jal hae
Ni geureon dongjeong ttawin pillyo eobseo uh

I said 1 and 2 and 3 4 ooh
Sigani modeungeol haegyeolhalgeoya
1 and 2 and 3 4 ooh
Game over game over ooh
Game over

Neomuna apa
Beolsseo ijeonna bwa
Hey baby
Tteonagajwo

I said 1 and 2 and 3 4 ooh
Sigani modeungeol haegyeolhalgeoya
1 and 2 and 3 4 ooh
Game over game over ooh
Game over

1 and 2 and 3 4
1 and 2 and 3 4
1 and 2 and 3 4

Game over
Game over
Game over