{"id":18390,"date":"2021-05-02T14:52:49","date_gmt":"2021-05-02T07:52:49","guid":{"rendered":"https:\/\/campuspedia.id\/news\/?p=18390"},"modified":"2021-05-02T15:02:54","modified_gmt":"2021-05-02T08:02:54","slug":"rumus-excel-dasar-wajib-banget-mahasiswa-tau","status":"publish","type":"post","link":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/","title":{"rendered":"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!"},"content":{"rendered":"<p><span style=\"font-size: 12pt;\"><i><span style=\"font-weight: 400;\">Hi Campuspedia Friends! <\/span><\/i>Kali ini mica bakal bahas rumus excel dasar, nih! <span style=\"font-weight: 400;\">Umum diketahui bahwa Ms.Excel adalah software pengolah angka terkenal dari <\/span><span style=\"font-weight: 400;\">Microsoft Corporation<\/span><span style=\"font-weight: 400;\">. Fungsi atau kegunaannya yang sangat beragam, menjadikan software ini menjadi pilihan pertama dalam pekerjaan sehari-hari. Seperti membuat, mengedit, mengurutkan, menganalisis, meringkas data hingga melakukan perhitungan aritmatika dan statistika.<\/span><\/span><\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Banyaknya manfaat dari penggunaan Ms.Excel tersebut tak terkecuali bagi mahasiswa. Mulai dari perhitungan data sederhana untuk laporan biasa, hingga olah data kompleks. Baik dari penelitian hingga\u00a0 skripsi.<\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Nah, sekarang kalian tau <\/span><i><span style=\"font-weight: 400;\">nggak<\/span><\/i><span style=\"font-weight: 400;\">? Minimal rumus-rumus Ms.Excel yang mana saja sih yang wajib mahasiswa tau? Simak penjelasan minca berikut, ya!<\/span><\/span><\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Oiya, sebagai informasi, rumus yang minca contohin di bawah menggunakan Ms.Excel 2016 yaa. Penggunaannya kurang lebih sama, hanya beberapa yang berbeda dan itu pun tidak jauh bedanya. Biasanya, program excel dalam laptop kalian, akan menyarankan secara otomatis rumus-rumus yang mereka punya saat kalian mengetik nama awalan rumus.<\/span><\/p>\n<h2><span style=\"font-size: 18pt;\"><b>KALIBATAKU (Kali, Bagi, Tambah, Kurang)<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Bukan hanya gurauan, jembatan keledai (singkatan) itu juga mengandung petunjuk untuk menentukan prioritas operasi hitung, loh!\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">Kali : Cukup tambahkan tanda (*) pada tab formula (yang dilingkari merah) antara 2 cell yang ingin kalian kalikan.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"size-full wp-image-18391 aligncenter\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/1.png\" alt=\"rumus excel\" width=\"366\" height=\"289\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/1.png 366w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/1-300x237.png 300w\" sizes=\"(max-width: 366px) 100vw, 366px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">Bagi : Tambahkan (\/) di tab formula<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18392\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/2.png\" alt=\"rumus excel pembagian\" width=\"415\" height=\"324\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/2.png 415w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/2-300x234.png 300w\" sizes=\"(max-width: 415px) 100vw, 415px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">Tambah : Ubah dengan tanda (+)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18393\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/3.png\" alt=\"rumus excel pertambahan\" width=\"400\" height=\"313\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/3.png 400w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/3-300x235.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">Kurang : Ubah dengan tanda (-)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18394\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/4.png\" alt=\"rumus excel pengurangan\" width=\"424\" height=\"333\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/4.png 424w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/4-300x236.png 300w\" sizes=\"(max-width: 424px) 100vw, 424px\" \/><\/span><\/p>\n<h2><span style=\"font-size: 18pt;\"><b>Statistik Sederhana (Max, Min, Count, Rata-rata, Median, Modus)<\/b><\/span><\/h2>\n<p>&nbsp;<\/p>\n<ul>\n<li aria-level=\"1\"><span style=\"font-size: 12pt;\"><b><span style=\"font-weight: 400;\">Max : Mencari nilai paling tinggi di rentang nilai. Rumusnya =MAX(cell1:cell2)<\/span><\/b><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18395\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/5.png\" alt=\"rumus max excel\" width=\"617\" height=\"237\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/5.png 617w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/5-300x115.png 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">MIN : Mencari nilai paling rendah di rentang nilai. Rumusnya =MIN(cell1:cell2)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18396\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/6.png\" alt=\"\" width=\"621\" height=\"244\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/6.png 621w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/6-300x118.png 300w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">COUNT : Menghitung jumlah data yang akan kita gunakan. Rumusnya =COUNT (cell1:cell2)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18397\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/7.png\" alt=\"rumus count excel\" width=\"549\" height=\"172\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/7.png 549w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/7-300x94.png 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Rata-rata (average) : Tulis =(AVERAGE ,\u00a0 pada cell hasil.\u00a0 Kalian hanya tinggal <\/span><i><span style=\"font-weight: 400;\">block <\/span><\/i><span style=\"font-weight: 400;\">cell yang hendak di hitung. Enter<\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18398\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/8.png\" alt=\"rumus rata-rata excel\" width=\"580\" height=\"252\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/8.png 580w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/8-300x130.png 300w\" sizes=\"(max-width: 580px) 100vw, 580px\" \/><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Median : Tulis =(MEDIAN ,\u00a0 pada cell hasil.\u00a0 Kalian hanya tinggal <\/span><i><span style=\"font-weight: 400;\">block <\/span><\/i><span style=\"font-weight: 400;\">cell yang hendak dihitung. Lalu pencet Enter.<\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18399\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/9.png\" alt=\"rumus median excel\" width=\"566\" height=\"248\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/9.png 566w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/9-300x131.png 300w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400; font-size: 12pt;\">Modus (nilai yang sering muncul) : Rumusnya =(MODE.SNGL<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18400\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/A.png\" alt=\"rumus modus excel\" width=\"574\" height=\"257\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/A.png 574w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/A-300x134.png 300w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/span><\/p>\n<h2><span style=\"font-size: 18pt;\"><b>SUM<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Rumus ini merupakan rumus dari pertambahan, namun dengan menggunakan rumus ini, kalian dapat menjumlahkan banyak angka pada cell.<\/span><\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Dengan menulis =SUM(cell1:cell2) kamu langsung dapat melihat hasilnya setelah dienter.<\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18401\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/B.png\" alt=\"rumus SUM excel\" width=\"613\" height=\"267\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/B.png 613w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/B-300x131.png 300w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/span><\/p>\n<h2><span style=\"font-size: 18pt;\"><b>SUMIF<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Rumus ini memang rumus pertambahan, tapi dia hanya menambahkan angka-angka sesuai kriteria yang diinginkan.<\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Rumusnya =SUMIF(<\/span><i><span style=\"font-weight: 400;\">range; \u201ccriteria\u201d; sum_range<\/span><\/i><span style=\"font-weight: 400;\">)<\/span><\/span><\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Keterangan :<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">range : rentang cell yang akan diproses<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">criteria : persyaratan yang harus dipenuhi(lihat contoh)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">sum_range : hal ini opsional. Jika kalian tidak mengisinya, maka yang akan ditambahkan adalah nilai pada cell <\/span><i><span style=\"font-weight: 400;\">range.<\/span><\/i><\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18402\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/C.png\" alt=\"rumus excel SUMIF\" width=\"695\" height=\"201\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/C.png 695w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/C-300x87.png 300w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/span><\/p>\n<p>&nbsp;<\/p>\n<blockquote><p><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Baca juga : <\/span><a href=\"https:\/\/campuspedia.id\/news\/prinsip-mahasiswa-keren\/\"><span style=\"font-weight: 400;\">Mau Jadi Mahasiswa Keren? Miliki 5 Prinsip Mahasiswa Keren Berikut Ini!<\/span><\/a> <\/span><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-size: 18pt;\"><b>Presentase<\/b><\/span><\/h2>\n<p><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Menampilkan nilai %, cukup membagikan cell seperti biasanya, akan tetapi pada kasus ini, kalian harus mengubah nilai ke dalam bentuk persen dengan menekan tombol (%) pada tab <\/span><b>Home.<\/b><\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18403\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/D.png\" alt=\"rumus excel presentase\" width=\"683\" height=\"129\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/D.png 683w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/D-300x57.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/span><\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Maka, hasil yang diperoleh akan menjadi seperti ini :<\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18404\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/E.png\" alt=\"rumus presentase excel\" width=\"470\" height=\"348\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/E.png 470w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/E-300x222.png 300w\" sizes=\"(max-width: 470px) 100vw, 470px\" \/><\/span><\/p>\n<h2><span style=\"font-size: 18pt;\"><b>VLOOKUP<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Fungsi rumus ini adalah menemukan berbagai hal di tabel atau rentang menurut baris. Misalnya, mencari nama belakang seseorang berdasarkan nama depannya, menemukan nama siswa sesuai dengan ID nya.<\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Rumusnya =VLOOKUP(<\/span><i><span style=\"font-weight: 400;\">lookup_value, table_array, column_number, [range_lookup]<\/span><\/i><span style=\"font-weight: 400;\">)<\/span><\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18405\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/F.png\" alt=\"rumus vlookup excel\" width=\"649\" height=\"203\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/F.png 649w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/F-300x94.png 300w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Mencari <\/span><i><span style=\"font-weight: 400;\">Putri <\/span><\/i><span style=\"font-weight: 400;\">dari kolom pertama (B) dalam <\/span><i><span style=\"font-weight: 400;\">tabel_array <\/span><\/i><span style=\"font-weight: 400;\">B2:B7, dan mengembalikan <\/span><i><span style=\"font-weight: 400;\">Arum <\/span><\/i><span style=\"font-weight: 400;\">dari kolom kedua (C) dari <\/span><i><span style=\"font-weight: 400;\">tabel_array. <\/span><\/i><span style=\"font-weight: 400;\">FALSE berarti mengembalikan yang sama persis.<\/span><\/span><\/p>\n<h2><span style=\"font-size: 18pt;\"><b>COUNTIF<\/b><\/span><\/h2>\n<p><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Menghitung jumlah data sesuai dengan syarat yang harus dipenuhi. Rumus dari COUNTIF adalah =COUNTIF(<\/span><i><span style=\"font-weight: 400;\">range; criteria<\/span><\/i><span style=\"font-weight: 400;\">). Kalimat singkatnya, kalian akan mencari dimana, lalu apa yang kalian cari?<\/span><\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18406\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/G.png\" alt=\"rumus countif excel\" width=\"595\" height=\"192\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/G.png 595w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/G-300x97.png 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/span><\/p>\n<h2><span style=\"font-size: 18pt;\"><b>IF<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Sederhananya dalam rumus ini, jika syarat yang telah disebut terpenuhi, maka lakukan perintah. Jika tidak, maka lakukan hal lain<\/span><\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Rumusnya =IF(Syarat_benar1;lakukan jika benar;lakukan jika tidak).<\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-18407\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/H.png\" alt=\"rumus excel if\" width=\"605\" height=\"286\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/H.png 605w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/H-300x142.png 300w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/span><\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Dalam kasus di atas, jika gaji (range yang dipilih) lebih dari 150, maka hasil yang ditampilkan akan BANYAK. Jika tidak, maka hasil yang ditampilkan akan SEDIKIT.<\/span><\/p>\n<p>&nbsp;<\/p>\n<blockquote><p><span style=\"font-size: 12pt;\"><strong><b>Baca juga : <\/b><a href=\"https:\/\/campuspedia.id\/news\/rekomendasi-website-jurnal-ilmiah-gratis\/\"><b>Tidak Perlu Pusing, Berikut 6 Rekomendasi Website Untuk Mencari Jurnal Secara Gratis<\/b><\/a>\u00a0<\/strong><\/span><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-size: 18pt;\"><b>MATCH<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Fungsi ini sangat berguna ketika kamu mencari data dalam suatu rentang. Rumusnya =MATCH(nilai_yg_dicari;range;match_type)<\/span><\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Match_type :\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">1 = Menemukan nilai terbesar yang lebih kecil dari atau sama dengan nilai_yg_dicari<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400; font-size: 12pt;\">0 = mencari nilai yang benar-benar sama.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">-1 = Menemukan nilai terkecil yang lebih besar dari atau sama dengan nilai_yg_dicari<\/span><img decoding=\"async\" class=\"aligncenter size-full wp-image-18408\" src=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/I.png\" alt=\"rumus excel match\" width=\"675\" height=\"311\" srcset=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/I.png 675w, https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/I-300x138.png 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Dalam kasus di atas, rumus minca berarti \u201cNilai 350 dalam range D2:D7 ada pada baris berapa?\u201d dan angka 0 menunjukkan minca mencari nilai yang benar-benar sama dengan apa yang minca cari. Tidak kurang ataupun lebih.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400; font-size: 12pt;\">Nah, itu tadi beberapa rumus Ms.Excel dasar yang setidaknya diketahui oleh mahasiswa maupun pelajar. Tentunya banyak sekali rumus-rumu Ms.Excel yang sangat bermanfaat untuk kita. Baik dalam dunia sekolah maupun dunia kerja.<\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><span style=\"font-weight: 400;\">Sekian dulu dari minca ya, <\/span><i><span style=\"font-weight: 400;\">Campuspedia Friends! <\/span><\/i><span style=\"font-weight: 400;\">Jangan lupa follow akun minca yang lain mulai dari <\/span><a href=\"https:\/\/www.instagram.com\/campuspedia\/?hl=id\"><span style=\"font-weight: 400;\">Instagram<\/span><\/a><span style=\"font-weight: 400;\">, <\/span><a href=\"https:\/\/www.linkedin.com\/company\/campuspedia-id\/\"><span style=\"font-weight: 400;\">LinkedIn<\/span><\/a><span style=\"font-weight: 400;\">, <\/span><a href=\"https:\/\/www.facebook.com\/campuspedia\"><span style=\"font-weight: 400;\">Facebook<\/span><\/a><span style=\"font-weight: 400;\">, <\/span><a href=\"https:\/\/twitter.com\/campuspedia_id\"><span style=\"font-weight: 400;\">Twitter<\/span><\/a><span style=\"font-weight: 400;\">, <\/span><a href=\"https:\/\/www.youtube.com\/channel\/UCPGrmZDHa5W4lCEudr8yYkA\"><span style=\"font-weight: 400;\">Youtube<\/span><\/a><span style=\"font-weight: 400;\">, dan <\/span><a href=\"https:\/\/page.line.me\/gso5731t\"><span style=\"font-weight: 400;\">Official Account LINE<\/span><\/a><span style=\"font-weight: 400;\"> biar kamu gak ketinggalan info seputar kampus, karir, dunia mahasiswa, beasiswa, dan info menarik lain.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi Campuspedia Friends! Kali ini mica bakal bahas rumus excel dasar, nih! Umum diketahui bahwa Ms.Excel adalah software pengolah angka terkenal dari Microsoft Corporation. Fungsi atau kegunaannya yang sangat beragam, menjadikan software ini menjadi pilihan pertama dalam pekerjaan sehari-hari. Seperti membuat, mengedit, mengurutkan, menganalisis, meringkas data hingga melakukan perhitungan aritmatika dan statistika. Banyaknya manfaat dari [&hellip;]<\/p>\n","protected":false},"author":1293,"featured_media":18410,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[137],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.10 (Yoast SEO v20.10) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!<\/title>\n<meta name=\"description\" content=\"Simak rumus-rumus Excel dasar berikut yang wajib diketahui oleh mahasiswa, pelajar, hingga pemula. Pastikan kamu udah tau ya!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!\" \/>\n<meta property=\"og:description\" content=\"Simak rumus-rumus Excel dasar berikut yang wajib diketahui oleh mahasiswa, pelajar, hingga pemula. Pastikan kamu udah tau ya!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/\" \/>\n<meta property=\"og:site_name\" content=\"Campuspedia News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/campuspedia\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-02T07:52:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-02T08:02:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/ms-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"322\" \/>\n\t<meta property=\"og:image:height\" content=\"157\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nur Izza Vania\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@campuspediaid\" \/>\n<meta name=\"twitter:site\" content=\"@campuspediaid\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nur Izza Vania\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/\"},\"author\":{\"name\":\"Nur Izza Vania\",\"@id\":\"https:\/\/campuspedia.id\/news\/#\/schema\/person\/586718098bc6c7334b6a18d87094e112\"},\"headline\":\"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!\",\"datePublished\":\"2021-05-02T07:52:49+00:00\",\"dateModified\":\"2021-05-02T08:02:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/\"},\"wordCount\":758,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/campuspedia.id\/news\/#organization\"},\"articleSection\":[\"Info\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/#respond\"]}],\"copyrightYear\":\"2021\",\"copyrightHolder\":{\"@id\":\"https:\/\/campuspedia.id\/news\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/\",\"url\":\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/\",\"name\":\"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!\",\"isPartOf\":{\"@id\":\"https:\/\/campuspedia.id\/news\/#website\"},\"datePublished\":\"2021-05-02T07:52:49+00:00\",\"dateModified\":\"2021-05-02T08:02:54+00:00\",\"description\":\"Simak rumus-rumus Excel dasar berikut yang wajib diketahui oleh mahasiswa, pelajar, hingga pemula. Pastikan kamu udah tau ya!\",\"breadcrumb\":{\"@id\":\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/campuspedia.id\/news\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/campuspedia.id\/news\/#website\",\"url\":\"https:\/\/campuspedia.id\/news\/\",\"name\":\"Campuspedia News\",\"description\":\"Kabar Seputar Kampus\",\"publisher\":{\"@id\":\"https:\/\/campuspedia.id\/news\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/campuspedia.id\/news\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/campuspedia.id\/news\/#organization\",\"name\":\"Campuspedia\",\"url\":\"https:\/\/campuspedia.id\/news\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/campuspedia.id\/news\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2019\/03\/ori_278.png\",\"contentUrl\":\"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2019\/03\/ori_278.png\",\"width\":278,\"height\":61,\"caption\":\"Campuspedia\"},\"image\":{\"@id\":\"https:\/\/campuspedia.id\/news\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/campuspedia\",\"https:\/\/twitter.com\/campuspediaid\",\"https:\/\/www.instagram.com\/campuspedia\",\"https:\/\/www.tiktok.com\/@campuspedia_id\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/campuspedia.id\/news\/#\/schema\/person\/586718098bc6c7334b6a18d87094e112\",\"name\":\"Nur Izza Vania\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/campuspedia.id\/news\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9eaff4a582d458de06a3d2722d343c4d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9eaff4a582d458de06a3d2722d343c4d?s=96&d=mm&r=g\",\"caption\":\"Nur Izza Vania\"},\"description\":\"Hola, I'm Vania, an industrial engineering student from Universitas Negeri Malang. Love to writing, talking, walking, and watching. A woman who is trying to be a happy person.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/nur-izza-vania-a404561a9\/\"],\"url\":\"https:\/\/campuspedia.id\/news\/author\/nivania27\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!","description":"Simak rumus-rumus Excel dasar berikut yang wajib diketahui oleh mahasiswa, pelajar, hingga pemula. Pastikan kamu udah tau ya!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/","og_locale":"en_US","og_type":"article","og_title":"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!","og_description":"Simak rumus-rumus Excel dasar berikut yang wajib diketahui oleh mahasiswa, pelajar, hingga pemula. Pastikan kamu udah tau ya!","og_url":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/","og_site_name":"Campuspedia News","article_publisher":"https:\/\/www.facebook.com\/campuspedia","article_published_time":"2021-05-02T07:52:49+00:00","article_modified_time":"2021-05-02T08:02:54+00:00","og_image":[{"width":322,"height":157,"url":"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/ms-excel.png","type":"image\/png"}],"author":"Nur Izza Vania","twitter_card":"summary_large_image","twitter_creator":"@campuspediaid","twitter_site":"@campuspediaid","twitter_misc":{"Written by":"Nur Izza Vania","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/#article","isPartOf":{"@id":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/"},"author":{"name":"Nur Izza Vania","@id":"https:\/\/campuspedia.id\/news\/#\/schema\/person\/586718098bc6c7334b6a18d87094e112"},"headline":"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!","datePublished":"2021-05-02T07:52:49+00:00","dateModified":"2021-05-02T08:02:54+00:00","mainEntityOfPage":{"@id":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/"},"wordCount":758,"commentCount":0,"publisher":{"@id":"https:\/\/campuspedia.id\/news\/#organization"},"articleSection":["Info"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/#respond"]}],"copyrightYear":"2021","copyrightHolder":{"@id":"https:\/\/campuspedia.id\/news\/#organization"}},{"@type":"WebPage","@id":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/","url":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/","name":"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!","isPartOf":{"@id":"https:\/\/campuspedia.id\/news\/#website"},"datePublished":"2021-05-02T07:52:49+00:00","dateModified":"2021-05-02T08:02:54+00:00","description":"Simak rumus-rumus Excel dasar berikut yang wajib diketahui oleh mahasiswa, pelajar, hingga pemula. Pastikan kamu udah tau ya!","breadcrumb":{"@id":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/campuspedia.id\/news\/rumus-excel-dasar-wajib-banget-mahasiswa-tau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/campuspedia.id\/news\/"},{"@type":"ListItem","position":2,"name":"Rumus Excel Dasar Berikut Ini Wajib Banget Kamu Mahasiswa Tau!"}]},{"@type":"WebSite","@id":"https:\/\/campuspedia.id\/news\/#website","url":"https:\/\/campuspedia.id\/news\/","name":"Campuspedia News","description":"Kabar Seputar Kampus","publisher":{"@id":"https:\/\/campuspedia.id\/news\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/campuspedia.id\/news\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/campuspedia.id\/news\/#organization","name":"Campuspedia","url":"https:\/\/campuspedia.id\/news\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/campuspedia.id\/news\/#\/schema\/logo\/image\/","url":"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2019\/03\/ori_278.png","contentUrl":"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2019\/03\/ori_278.png","width":278,"height":61,"caption":"Campuspedia"},"image":{"@id":"https:\/\/campuspedia.id\/news\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/campuspedia","https:\/\/twitter.com\/campuspediaid","https:\/\/www.instagram.com\/campuspedia","https:\/\/www.tiktok.com\/@campuspedia_id"]},{"@type":"Person","@id":"https:\/\/campuspedia.id\/news\/#\/schema\/person\/586718098bc6c7334b6a18d87094e112","name":"Nur Izza Vania","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/campuspedia.id\/news\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9eaff4a582d458de06a3d2722d343c4d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9eaff4a582d458de06a3d2722d343c4d?s=96&d=mm&r=g","caption":"Nur Izza Vania"},"description":"Hola, I'm Vania, an industrial engineering student from Universitas Negeri Malang. Love to writing, talking, walking, and watching. A woman who is trying to be a happy person.","sameAs":["https:\/\/www.linkedin.com\/in\/nur-izza-vania-a404561a9\/"],"url":"https:\/\/campuspedia.id\/news\/author\/nivania27\/"}]}},"fimg_url":"https:\/\/campuspedia.id\/news\/wp-content\/uploads\/2021\/05\/ms-excel.png","post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/posts\/18390"}],"collection":[{"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/users\/1293"}],"replies":[{"embeddable":true,"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/comments?post=18390"}],"version-history":[{"count":0,"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/posts\/18390\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/media\/18410"}],"wp:attachment":[{"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/media?parent=18390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/categories?post=18390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/campuspedia.id\/news\/wp-json\/wp\/v2\/tags?post=18390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}