Bisa dicoba file terlampir...
From: IHSAN NURDIN [email protected] [belajar-excel] [mailto:[email protected]] Sent: 24 Desember 2014 09:34 To: BeExcel Subject: [belajar-excel] range vlookup YTH rekan2 milis. Mohon bantuan rekan2 Sy punya data seperti dibawah ini : Tabel nilai Nilai Keterangan 0 - 40 = Sangat kurang 41 - 59 = kurang 60 = cukup 61 = lumayan 62 = lumayan baik 63 - 70 = cukup Baik 71 - 80 = Baik 81 - 90 = sangat baik 91 - 95 = Baik sekali 96 - 100 = Sempurna Hasil ujian murid : Nama Nilai Ujian Keterangan Ahmad 40 ? Ali 47 ? Razak 93 ? dst.. Pertanyaan : bagaimana mengisi keterangan dari tabel nilai di atas? TK atas bantuannya. Wassalam _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
Mr. Ihsan.xlsx
Description: MS-Excel 2007 spreadsheet
