Bom sesuai kang Bagus, coba dah di isi yang bagian "Praktek Harian" dengan nilai di atas KKM
PRAZTMATH T From: [email protected] [mailto:[email protected]] On Behalf Of Bagus Sent: 04 September 2013 15:30 To: [email protected] Subject: Re: [belajar-excel] Ketercapaian Kompetensi Ooo... Baru Ngeh Bozz.. Coba ganti formula yg ada di CO21 yg warna merah =CONCATENATE(IF(OR(AND(BT21=1,BZ21="O"),AND(BT21=2,BZ21="O",CA21="O"),AND(BT 21=3,BZ21="O",CA21="O",CB21="O"),AND(BT21=4,BZ21="O",CA21="O",CB21="O",CC21= "O"),AND(BT21=5,BZ21="O",CA21="O",CB21="O",CC21="O",CD21="O"),AND(BT21=6,BZ2 1="O",CA21="O",CB21="O",CC21="O",CD21="O",CE21="O"),AND(BT21=7,BZ21="O",CA21 ="O",CB21="O",CC21="O",CD21="O",CE21="O",CF21="O"),AND(BT21=8,BZ21="O",CA21= "O",CB21="O",CC21="O",CD21="O",CE21="O",CF21="O",CG21="O"),AND(BT21=9,BZ21=" O",CA21="O",CB21="O",CC21="O",CD21="O",CE21="O",CF21="O",CG21="O",CH21="O")) ,CONCATENATE(" semua ",$CN$3),IF(AND(S21>=BS21,T21<>"R"),CONCATENATE(" ",$CN$2," ",$CN$4),IF(OR(BZ21="O",CA21="O",CB21="O",CC21="O",CD21="O",CE21="O",CF21="O ",CG21="O",CH21="O"),CONCATENATE(" ",$CN$3),"")))) ganti dengan $CN$3 Wassalam ~ Bagus ~ ----- Original Message ----- From: prazt math <mailto:[email protected]> To: [email protected] <mailto:[email protected]> Sent: Wednesday, September 04, 2013 2:45 PM Subject: Re: [belajar-excel] Ketercapaian Kompetensi Malah kagak ada kriterianya bos, jadi hilang malah yg no urut 1&3 Pada 4 Sep 2013 14:19, "Bagus" <[email protected] <mailto:[email protected]> > menulis: Pak Prazt; Coba ganti formula yg ada di AL21 =IF(OR(F$11=0,F$11=""),"",IF(OR(U21="",AI21=""),"",CP21)) menjadi =IF(OR(F$11=0,F$11=""),"",IF(OR(U21=0,AI21=0),"",CP21)) Copy kebawah Wassalam ~ Bagus ~ ----- Original Message ----- From: PRAZT <mailto:[email protected]> To: group excel <mailto:[email protected]> Sent: Wednesday, September 04, 2013 1:38 PM Subject: [belajar-excel] Ketercapaian Kompetensi Dari ubun-ubun sampai ujung jempol kaki, dari si A sampai ke z ternyata masih cetek juga tentang excel...karena sudah cenut-cenut ni kepala, tolonglah bantu menyelesaikan file terlampir berikut para master, supaya pada "Ketercapaian Kompetensi" siswa bisa sesuai dengan harapan...mau njelasin puanjang jadi langsung cekidot aja.... PRAZTMATH T
<<image001.png>>
<<image002.png>>
<<image003.gif>>
<<image004.png>>
