Acuan Rumus Menghitung Persen(%) Di Excel

Segala sesuatu perhitungan dapat dijalankan dengan memakai Microsoft Excel, Contohnya perkiraan persentase yang biasanya lazim kita temui di keseharian.


Persentase atau arti sesungguhnya yakni seperseratus yakni adalah sebuah angka atau perbandingan (rasio) untuk menyatakan cuilan dari seratus. Persentase sering ditunjukkan dengan simbol “%”. Persentase juga dipakai walaupun bukan bagian ratusan. Bilangan itu lalu diskalakan supaya mampu ketimbang seratus. (id.wikipedia.org).


Menghitung Persentase (%)


Rumus dasar persentase  pada ilmu mate-matika ialah:


Rumus Dasar PersenSebagai acuan soalnya:


Contoh Soal

Pak Budi berbelanja jeruk seharga Rp.25.000 per Kg. Kemudian jeruk tersebut dijual kembali oleh Pak Budi sebesar Rp. 35.000. Berapa persen laba yang ditemukan oleh Pak Budi?


Jawab:


Keuntungan = Rp 35.000 – Rp 25.000 => Rp 10.000


Persentase keuntungan (%) = Rp 10.000/ Rp 25.000 x 100% => 40%


Jika perkiraan tersebut dimasak atau tertuntaskan dengan menggunakan Excel maka penyelesaiannya selaku berikut.


menghitung persen di ExcelAda 4 kolom tabel yaitu A2=Harga Beli; B2=Harga Jual; C2=Keuntungan dan D2 yakni Persen Keuntungan. Untuk menghitungnya letakkan kursor di cell D2, lalu ketikkan rumus =(C2/A2) lalu ENTER.


Maka karenanya yakni 0,4. Untuk menimbulkan angka persen silahkan anda pilih tombol % pada format Number. Maka nilai tersebut akan bermetamorfosis 40%.


Nah itulah Tutorial Excel secara singkat, jikalau ada yang belum terperinci silahkan tanyakan kepada aku. Anda mampu mengajukan request postingan terkait pembahasan rumus Excel dengan mengirimkan email ke saya. Terimakasih semoga berguna.


Comments

Post a Comment

Popular posts from this blog

Recipe: Delicious Loaded Potato Nachos

Image
Loaded Potato Nachos . You can cook Loaded Potato Nachos using 20 ingredients and 16 steps. Here is how you cook it. Ingredients of Loaded Potato Nachos You need of Meat-----------------. It's 4 slices of bacon, 2 ounces. Prepare 6 ounces of chicken thigh boneless and skinless. Prepare 1-1/2 pound of ground beef. You need 15 ounce of can of pinto beans. Prepare 1 teaspoon of kosher salt. Prepare 1-1/2 teaspoon of ground cumin. Prepare 1 teaspoon of granulated garlic powder. Prepare 1-1/2 teaspoon of ground paprika. It's 2 tablespoons of tomato paste. Prepare 1 teaspoon of onion powder. You need of Potatoes----------------. It's As needed of oil to fry in. It's 1-1/2 pound of yellow potatoes. You need To taste of salt. It's of Cheeses and other----------------. Prepare 12 ounces of Colby pepper jack cheese. Prepare 4 ounces of sliced ba...
Read more

Recipe: Yummy Turkey nachos

Image
Turkey nachos . I may just have to declare this as the best use for leftover turkey!! (also declared the best thing ever by Lewis and Gracey. Turkey sandwich, Turkey Nachos, Turkey stir fry! What you need to make Loaded Turkey Nachos Salad Bowls: Leftover Turkey (Roasted, Oven baked, or Smoked, etc.) These turkey nachos turn your leftover turkey stash into a cheesy, crunchy, spicy, gluten-free party food that will be scooped up in seconds! Taco seasoning and a splash of beer create a flavorful base for these nachos. Feel free to mix up the ingredients—substitute black beans. In a skillet, brown the turkey; drain. You can have Turkey nachos using 8 ingredients and 7 steps. Here is how you achieve it. Ingredients of Turkey nachos You need 1 lb of ground turkey. Prepare 1/2 of red onion diced. It's of Sweet bell peppers or stop light peppers diced. It's of Diced jalapeño. You need of Diced tomatoes. It's ...
Read more

Recipe: Yummy Nacho Cheese Dorito Casserole

Image
Nacho Cheese Dorito Casserole . These useful spices can be used to cook so many different meals! I just love this wonderful and cheesy casserole. It freezes well and is delicious for all those cheese lovers in your family. Corn, Vegetable Oil (Corn, Canola, And/or Sunflower Oil), Maltodextrin (Made From Corn), Salt, Cheddar Cheese (Milk, Cheese Cultures, Salt, Enzymes), Whey, Monosodium Glutamate, Buttermilk, Romano Cheese (Part-skim Cow's. Layered Dorito Casserole is an easy family favorite recipe! Lean ground beef is seasoned with taco Layers of Doritos create a delicious base for this casserole which is then topped with cheese and baked until brown and bubbly. You can have Nacho Cheese Dorito Casserole using 14 ingredients and 4 steps. Here is how you cook it. Ingredients of Nacho Cheese Dorito Casserole It's 1 lb of ground beef. It's 1 bag of nacho cheese doritos. You need 1 of dice onion. You need 3-4 of garlic c...
Read more