Multi if digunakan untuk menguji suatu kondisi
Bentuk Penulisan Fungsi : =IF(X,Y,Z)
=IF(F2<60,"D",IF(F2<80,"C",IF(F2<90,"B","A")))
Pertama Tulis tabel dibawah ini :
 |
| gambar 1 |
setelah tabel diatas tulis rumus pada kolom NILAI HURUF lihat gambar
This is default featured slide 1 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
This is default featured slide 2 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
This is default featured slide 3 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
This is default featured slide 4 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
This is default featured slide 5 title
Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.
Senin, 23 April 2012
Minggu, 22 April 2012
Cara Menentukan Ranking Menggunakan Microsoft Excel
Cara Menentukan Ranking Menggunakan Microsoft Excel sangat dibutuhkan oleh Wali Kelas di tiap sekolah Baik di tingkat SD,SMP & SMA. Dengan menggunakan Rumus Excel akan sangat mempermudahkan dan menghemat waktu bila dibandingkan dengan cara manual berikut rumus & contohnya
Rumus
=RANK($C$2:$C$11,$C$2:$C$11,0)
Rumus
=RANK($C$2:$C$11,$C$2:$C$11,0)
Langganan:
Postingan (Atom)
