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.

Sunday, March 22, 2015

Format Bersyarat dengan Custom Format pada MS Excel

Excel memiliki kemampuan format bersyarat. Berikut ini adalah cara memformat dengan syarat nilai tertentu dengan huruf warna merah [Red]. Untuk memformat bersyarat dengan Custom Format susunan penulisannya sebagai berikut :
[Warna][Syarat 1] format angka;[Warna][Syarat 2] format angka;[Warna] format bilangan bila tidak memenuhi syarat 1 maupun 2

contoh :
[Black][>=1000]#,##0.00;[Blue][<=500]0.00;[Cyan]0.00