Fungsi MIN pada Excel
|
|
|
Fungsi MIN digunakan untuk mencari nilai terendah atau nilai minimal dari sekelompok bilangan. Perlu digaris bawahi, data yang bisa diproses hanya data yang berupa angka.
Bentuk umum penulisan Fungsi MIN adalah sbb :
=MIN(number1;number2;…)
Keterangan :
number1, number2, number3 adalah bilangan atau alamat range data numerik. Number ini dapat anda tentukan sendiri sampai batas maksimum sebanyak 30 untuk Excel 2003 dan 255 untuk Excel 2010.
Contok Penulisan rumus :
Berdasarkan tabel data dibawah ini, kita dapat mengerjakan rumusnya sbb :
=MIN(B3:B10)
=MIN(B3;B4;B5;B6;B7;B8;B9;B10)
Please enter your email to get latest articles straight to your email. FREE!. If you do not know how to subscribe via email, Read Here What is RSS?
|
|
|
|
1 comments terhadap "Fungsi MIN pada Excel"
mantep tutorial microsoftnya gan :)
On Yahoo Messenger Smileys
Please write your comments on the options Google/Blogger for those of you who have an account Google/Blogger. Please select the account in accordance with blog/website your (LiveJournal, WordPress, TypePad, AIM). At the option OpenID please enter URL blog/website you are in the box provided. Or you can choose options Name/URL, then write your name and URL blog/website you are in the box provided. If you do not have blog/website, column URL allowed to leave the field blank. Use option 'Anonim' if you do not want to publish your data.(highly discouraged).If your comment in the form of questions, so if you use this option will not be addressed.
As a seeker of information to say what is your opinion regarding "Fungsi MIN pada Excel".