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(BT21=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,BZ21="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
To: [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]> 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
To: group excel
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 ™
<<image001.gif>>
<<image003.png>>
<<image002.png>>

